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:

• combo box for finding records
• Space marks
• Compact database automoatically