Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-11-2004, 11:21 PM   #1
xDamian
Registered User
 
Join Date: Feb 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
xDamian
Thumbs up Formatting Numbers

Hi

Is there a simple way to display numbers entered as 3-digits - eg 007?

My user has an invoice reference which consists of a pre-fix (eg 'INV') and then an automatically generated number (eg 7).

Rather than the invoice reference be displayed as 'INV-7', they would prefer see it as 'INV-007'.

Grateful for any solutions / advice.

Cheers

D

xDamian is offline   Reply With Quote
Old 02-12-2004, 12:46 AM   #2
saintsman
Newly Registered User
 
Join Date: Oct 2001
Location: Bournemouth, UK
Posts: 138
Thanks: 2
Thanked 0 Times in 0 Posts
saintsman
In the field's properties put 000 in the "format" line.
saintsman is offline   Reply With Quote
Old 02-12-2004, 01:52 AM   #3
xDamian
Registered User
 
Join Date: Feb 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
xDamian
Thanks - that worked a treat!

xDamian is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 10:44 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World