Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: using Null Values

    I have made a form that queries info from a table. On this form I have a field in which the user needs to type a value that is formated to be a currency value. If the value is not needed I don't want the $0.00 to show up when I merge the results into word. If you have any idea how to do this please let me know. Thanks.

    TJ

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    The field you are storing the data into needs to have not default. Access automatically assumes you want a number field to be zero if nothing is entered. You'll have to design the table and remove the default for that field. Then for any new records that are added the number will be null unless someone enters a number.

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    Thanks a bunch. That worked perfectly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •