Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Access hints and tips » Prefixed Autonumbering
Prefixed Autonumbering
When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.
For example, P001, where P is the prefixed letter
Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000
Added by Orok on 27th September 2006
More Access hints and tips, like:
 |
|
» Forum post: Offsets |
When are offsets used?
