private void Department_Enter( object sender, EventArgs e )
		  {
				strTextChangedEnter = ( ( TextBox )sender ).Text;
				( ( TextBox )sender ).Font = new Font( this.Font.Name, 11, FontStyle.Bold );
				( ( TextBox )sender ).BackColor = Color.FromArgb( cbR, cbG, cbB );
		  }

private void Department_Leave( object sender, EventArgs e )
		  {
				strTextChangedLeave = ( ( TextBox )sender ).Text;
				( ( TextBox )sender ).Font = new Font( this.Font.Name, 10, FontStyle.Regular );
				( ( TextBox )sender ).BackColor = SystemColors.Window;

				if ( strTextChangedEnter != strTextChangedLeave )
				{
					 CompNo2 = Convert.ToInt32( dataGridView2.Rows[ dataGridView2.CurrentRow.Index ].Cells[ 0 ].Value.ToString() );
					 CustNo2 = Convert.ToInt32( dataGridView2.Rows[ dataGridView2.CurrentRow.Index ].Cells[ 1 ].Value.ToString() );
					 ContactNo2 = Convert.ToInt32( dataGridView2.Rows[ dataGridView2.CurrentRow.Index ].Cells[ 2 ].Value.ToString() );
					 int iErr = 0;

					 switch ( ( ( TextBox )sender ).Name )
					 {
						  case "Email":
								clsValidateEmail.clsValidEmail( ( ( TextBox )sender ).Text.Trim() );

								if ( clsValidateEmail.Val_emCorrect == 1 )
								{
									 errorProvider1.SetError( ( ( TextBox )sender ), "" );
								}
								else
								{
									 errorProvider1.SetError( ( ( TextBox )sender ), "ERROR !" );
									 ( ( TextBox )sender ).Focus();
									 SendKeys.Send( "{RIGHT}" );
								}
								break;
						  case "WorkExtension":
								break;
						  case "CreditCardNo":								
								string strOK = "";
								//string iShortLong = "";
								errorProvider1.SetError( ( ( TextBox )sender ), "" );						  
								if ( ( ( TextBox )sender ).Text.Length < 16 )
								{		
									  iErr = 1;
									  strOK = "is too Short by " + Convert.ToString( 16 - ( ( TextBox )sender ).Text.Length ) + " Numbers";
									// iShortLong = Convert.ToString( 16- (( TextBox )sender ).Text.Length );
									 errorProvider1.SetError( ( ( TextBox )sender ), "ERROR !" );						  
								} 
								else	 if ( ( ( TextBox )sender ).Text.Length > 16 )
								{
									  iErr = 1;
									  strOK = "is too Long by " + Convert.ToString( ( ( TextBox )sender ).Text.Length - 16 ) + " Numbers";
//iShortLong = Convert.ToString( (( TextBox )sender ).Text.Length - 16) ;
									 errorProvider1.SetError( ( ( TextBox )sender ), "ERROR !" );						  
								}
								else if ( ( ( TextBox )sender ).Text.Length == 16 )
								{
									 int iRow;									 
									 for ( iRow = 0; iRow < 16; iRow++ )
									 {
										  if ( char.IsNumber( Convert.ToChar( ( ( TextBox )sender ).Text.Substring( iRow, 1 ) ) ) ) { } else { strOK = " has Characters  in it . "; iErr = 1; }
									 }
								}	
								
								if ( iErr == 1)
								{
									 DialogResult result = MessageBox.Show( "\nCredit Card Not Valid ?\n\nCredit Card No. " + strOK + "\n\nPlease Correct !", "E R R O R ! Credit Card entry Not Valid ? ", MessageBoxButtons.OK, MessageBoxIcon.Warning );
									 CreditCardNo.Focus();
								}
								break;
					 	  default: //sCompany,sAddress1,sAddress2
								( ( TextBox )sender ).Text = clsCapitalizeFirstWord.clsCapFirstWord( ( ( TextBox )sender ).Text.Trim() );
								break;
					 }
					 if ( iErr != 1 )
					 {
						  clsTableAltering.taTableAlteringType = "UpDate"; // DeleteRow , UpDate, Select, Insert
						  clsTableAltering.taTableName = "CustomerContacts";
						  clsTableAltering.taSelectCol = ( ( TextBox )sender ).Name + " = '" + ( ( TextBox )sender ).Text.Trim() + "'";
						  clsTableAltering.taTableWhere = "(CompanyID = " + "'" + CompNo2 + "'" + ")" + " AND "
										  + " ( " + "  CustomerID = " + "'" + CustNo2 + "'" + " )" + " AND "
										  + " ( " + "  ContactID = " + "'" + ContactNo2 + "'" + " )";
						  clsTableAltering.taTableOrderedBy = "CompanyID, CustomerID, ContactID ";
						  clsTableAltering.clsTableUpDate();
					 }
					 //CustomerStatus.BackColor = Color.Red;
				}
				else
				{
					 // CustomerStatus.BackColor = Color.White;
				}
		  }