Re: How do I set a default value?
From: Graham Mandeno (Graham.Mandeno_at_nomail.please)
Date: 02/07/05
- Next message: Joe Holzhauer: "Re: "Return Value" for a form?"
- Previous message: Dirk Goldgar: "Re: "Return Value" for a form?"
- In reply to: Raj: "How do I set a default value?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 07:00:39 +1300
Hi Raj
What you need to set here is not the *value*, but the *format*.
Set the Format property of yout textbox (or field) to "000". Then any value
with fewer than three digits will display with leading zero(es).
-- Good Luck! Graham Mandeno [Access MVP] Auckland, New Zealand "Raj" <Raj@discussions.microsoft.com> wrote in message news:23D8ED40-07EE-4069-9F2E-ED325C0CB25F@microsoft.com... > Hi, > How do i set a default value of three 0's. I have forced it to be 3 > digits. > but if i enter 012 it becomes 12. I want it to force it to have a default > value of 000 if nothing is entered. > > Thanks for your help in advance.
- Next message: Joe Holzhauer: "Re: "Return Value" for a form?"
- Previous message: Dirk Goldgar: "Re: "Return Value" for a form?"
- In reply to: Raj: "How do I set a default value?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|