Access 2007: Formatting a text field in a datasheet

D

Doug

A few questions:

1. How do I format a text field to get leading zeroes, e.g. if I enter 321
into the field it will display as 000321. (I know how to do this with a
numeric field, but not a text field.)

2. What is the difference between the @ format and the & format in a text
field in an Access 2007 table? I can see no difference playing with these
two formats.

3. Does anyone know where I can find good/comprehensive examples online for
formatting fields of the different data types in an Access table?

Thanks,

Doug
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Delete all data after a symbol in a field 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Autonumber field in Excel that behaves the same as Access 0
Formatting Text from Excel 1
Help creating a search form in Access XP 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Hidden Field in Datasheet view for a table 5

Top