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

Errors in Autonumber ID field 4
Hidden Field in Datasheet view for a table 5
Import from Excel 3
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Access 2007 format text box options not displayed 2
Access Access - Is it possible to repeat fields in a form? 1
Text Field Capitalization 2
Count text values in a Access Field 0

Top