Access 2007 format text box options not displayed

[prokopof]

I am trying to apply some format for my text filed in a table in Access 2007.
When I click on "Format" in Field Properties window only blank list shows up
with no options. If I want to apply format to Number type everything works
great and all available options are displayed. The same thing happens with
Memo type. No options to set up format field are displayed. How can I fix it?
Thanks a lot!

 

[Duane Hookom]

What format would you expect to apply to a text field? Formats are generally
associated with numeric and date/time fields.

 

[Bob Larson]

And to go along with what Duane said, you really shouldn't format at the
table level. You should apply the formats you want at the very point you
are either using or displaying the data.


--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

Free Access Tutorials and Resources: http://www.btabdevelopment.com