If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007: Formatting a text field in a datasheet
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 |
#2
|
|||
|
|||
Access 2007: Formatting a text field in a datasheet
Format([YourField], "000000")
"Doug" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|