Re: How do I set a default value?

From: Graham Mandeno (Graham.Mandeno_at_nomail.please)
Date: 02/07/05


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. 


Relevant Pages

  • Re: Cobol Myth Busters
    ... than just TRUNC (wich has 3 flavors on IBM zSeries). ... using 18 digits: packed decimal is 74% faster than binary ... packed decimal is 60% slower than binary ... DISPLAY compared to packed decimal ...
    (comp.lang.cobol)
  • Re: FPGA Journal Article
    ... 10 decimal digits fixed-point display, ... Above 1 MHz limited by time base accuracy, below 1 MHz by display ... but clutter up the design. ... A 20 times more accurate time base would cost <$20 extra. ...
    (comp.arch.fpga)
  • Re: Price Data Formatting
    ... When you load in a datafile of a stock or commodity, ... only 3 digits following the decimal rather than 4. ... So when I display prices in my application, I want to use the SAME format as ... It doesn't fit well in my textboxes for display. ...
    (microsoft.public.vb.general.discussion)
  • Re: Reducing load for LAMP app?
    ... Using microtime() as-is: 2.6941299438477E-5 ... 2.6941299438477E-5 is standard scientific notation for display of very large or very small numbers. ... Another point here is that floating point numbers have up to 15 significant digits ... I'd suggest you follow up in the Linux admin groups - where the experts hang out. ...
    (comp.lang.php)
  • Re: 7-bar display
    ... I would like to display digits with a 7-bar display, ... mitred just like on a pocket calculator. ... Maybe the font solution would be best. ... I just thought of another way you could do your calculator digits. ...
    (comp.infosystems.www.authoring.html)