Access 2007: Formatting a text field in a datasheet

  • Thread starter Thread starter Doug
  • Start date Start date
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
 
Back
Top