Phone number formatting.

[raghuprabhu]

Hi to One and All,

I have attached a small database in 2003 format. We have three different formats for phone numbers
Normal format (03)92823600, Free calls 1800-464-444 or Mobiles 0421-458-555 (same formatting) and Short format 131-181.

It was decided at my work that we use one phone number per record. There is NO problem with “tblMain” and “frmMain” in columnar format. There are two slight problems with this database.


First Problem.

I also created “sFrmmain” using “tblMain” in datasheet format. When the cursor is in record where there is a phone number format selected and the phone number input, the phone number field is enabled. If on the other hand if the cursor is in the record without the phone format selected, it is disabling the telephone numbers in other records. Same problem with “frmTestWithMainAsSubform”! How do I fix this?


Second Problem.
I also created a table called “tblContacts” it is different from “tblMain” and has extra fields called “companyName” and “IDMain”. I used this to create a form “sFrmContacts” in datasheet view. This I used as a subform in the form “frmMainWithContactsAsSubform”. What is happening with the code in the “sFrmContacts” of the attached database? There is a problem with “Form_Current” event of this subform. How do I fix this?

thanks to one and all in advance.

 

[missinglinq]

First Problem

This type of formatting in Datasheet/Continuous View Forms has to be done using Conditional Formatting which, fortunately, can control Enabling/Disabling.

The only types of formatting that can be done, in these types of forms, using code in the Form_Current event is Locking or Locking and Disabling the Control. That's because these types of formatting do not change the appearance of the Control.

Second Problem

"... What is happening with the code in the “sFrmContacts” of the attached database? There is a problem with “Form_Current” event of this subform. How do I fix this?"

I'll bite! What is happening? Or not happening, as the case may be? I can't download your app right now, and many people here refuse to do so at any time, so an explanation would be helpful.

Linq ;0)>