Results 1 to 3 of 3
  1. #1
    pgmclement is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    2

    Make Unbound text box to default zero

    • Hi.


      I have a report that sometimes when I sum two columns together
      e.g. Credit-Debit
      On the report, it might generate it has 0.00 while on print preview, it goes blank.
      What can I do to make sure that the report I print preview shows that same record of 0.00 instead of going blank.
      Thanks.




  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Have you tried using the Nz() function.
    Maybe something like:
    Nz(Credit-Debit,0)
    Last edited by Bob Fitz; 10-26-2016 at 04:42 AM. Reason: spelling corection
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    or use the format property (not function) - for numbers there are 4 parts, positive;negative;zero;null

    see this link

    https://support.office.com/en-us/art...rs=en-US&ad=US

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-26-2015, 11:31 PM
  2. Replies: 5
    Last Post: 01-30-2015, 02:45 PM
  3. Replies: 3
    Last Post: 05-15-2014, 03:38 PM
  4. Default value on an unbound combo box
    By lsmcal1984 in forum Forms
    Replies: 1
    Last Post: 10-10-2013, 06:40 AM
  5. Replies: 3
    Last Post: 08-15-2013, 03:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums