Changing a Field Format

[lwinford]

Hi,

I have a field which contains Phone 000-0000 I want to display it as (000) 000-0000.


I changed the format in the Table but it is not being updated in the Form. Please help?
Thanks!

[June7]

Changing format property in tables does not affect controls already created unless you confirmed 'Update format everywhere' in the table. Fix the Format property of the textbox on form.

[lwinford]

Changing format property in tables does not affect controls already created unless you confirmed 'Update format everywhere' in the table. Fix the Format property of the textbox on form.

Could you tell me how to "update format everywhere" in the table and also how to fix the format property of the textbook form. I go into Datasheet view and Design view and can't locate the function to update.

[June7]

Table in design view, type something in the Format property, should see a box to the left with a lightning bolt. Click and make choice.

Form in design view, select textbox, Format tab of property sheet.