setting default value to $0.00 in a currency field

Discussion in 'Microsoft Access' started by Guest, Oct 25, 2004.

  1. Guest

    Guest Guest

    I have set the default value in both the table and the form but neither
    works. I need to have $0.00 show by default
     
    Guest, Oct 25, 2004
    #1
    1. Advertisements

  2. Guest

    Allen Browne Guest

    1. Open the table in design view.

    2. Select the currency field.

    3. In the lower pane, set the Format to:
    Currency
    and the Default Value to:
    0

    Check that this works as expected when you open the table. Then, if
    necessary, clear the Default value and Format properties of the text box on
    your form (or set them the same way).

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "rburek" <> wrote in message
    news:...
    >I have set the default value in both the table and the form but neither
    > works. I need to have $0.00 show by default
     
    Allen Browne, Oct 25, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    8
    Views:
    275
    Guest
    Aug 11, 2005
  2. Guest

    Not accept a value of 0 in a currency field.

    Guest, Jul 6, 2007, in forum: Microsoft Access
    Replies:
    3
    Views:
    175
    Guest
    Jul 6, 2007
  3. Akilah
    Replies:
    1
    Views:
    931
    Al Campagna
    Jan 17, 2008
  4. Marg
    Replies:
    2
    Views:
    201
    Allen Browne
    Jul 2, 2009
  5. Rustle
    Replies:
    3
    Views:
    379
    Bob Quintal
    Jun 30, 2011
Loading...

Share This Page