Combo Box Field Property setting 1

[w8n]

Access 2000 in Windows 98 SE. I have a four column combo box that uses an SQL statement as its Row Source. The returned data is correct. Two of the columns in this Combo Box are Phone numbers, and I would like to set an appropriate Input mask. I have attempted to go into the Query Builder and set the Field Properties for each column individually, but the Properties won’t stay. I select the column, left-click, Properties, and on the General tab, fill in the appropriate Input Mask for phone number. After exiting the Query Builder, I immediately go back in to check the Field Properties, only to find the Input Mask has been blanked out. The data being grabbed is correctly masked in its table, but is NOT masked in the Combo Box. Is there a way to set the Field Property through Visual Basic, or some other method? Am I not saving the Field Properties correctly? Perhaps Access 2000 has an oddity with Field Settings? Any info is appreciated in advance. W8n

 

[wemeier]

You could try this:

In your SQL statement, instead of just selecting the phone number, format it. For example, instead of:

SELECT NAME, PHONE FROM TABLE

use this:

SELECT NAME, FORMAT(TABLE.PHONE,"000-000-0000&quot AS PHONE FROM TABLE



Cruising the Information Superhighway
[sub] (your mileage may vary)[/sub]

 

[w8n]

Thanks a TON, wemeier! This was exactly what this DBer needed, and in a SUPER fast time frame. Thanks for spreading the knowledge. - W8n