set a default area code either in text box or field

[DougP]

In the design of the customers table I would like to put the default area code 813 in. I pout it in the default value but when a new record is created it put it as the last 3 of the phone number not the first 3. as shown ( ) ___ - _813
This is done when a new record is added from a form

Default value in table 813
How do I force the 813 to be in the first three like so, (813) ___ - ____

BTW: I also found out already to force the starting position to the 5 character which works fine.
Me![Phone].SelStart = 5
Me![Phone].SelLength = 1
TIA


DougP
< I Built one

http://www.robots2000.com

 

[lameid]

Hmmm...

Try on the contols Got Focus event to set the text property to 813 if the control is empty.

 

[lameid]

That is a control on a form solution not a table solution.

 

[DougP]

does not work either
and if the area code is different then every time you enter the text box it overwrites it and puts 813.


DougP
< I Built one

http://www.robots2000.com

 

[dhookom]

Why not split the data into two fields [AreaCode] and [Phone]?

I detest input masks but that's generally my problem ;-)

Duane
Hook'D on Access
MS Access MVP