Results 1 to 3 of 3
  1. #1
    TINMAN is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    64

    #Size! Error

    I am trying to use the Nz function to print a line if a field is blank. The Nz function is shown below:



    =Nz([Child FirstName],"______________________________")

    I have used this function successfully on another report based on a suggestion on a thread I posted earlier, but this time I am getting the error message shown below:


    #Size!

    What am I doing wrong that is resulting in this error message on this particular report?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,515
    Make sure there isn't a control on the form with the same name. That can confuse Access.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    TINMAN is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    64

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

Similar Threads

  1. Error (#Size) Error (#Type)
    By Kundan in forum Reports
    Replies: 8
    Last Post: 04-18-2018, 03:42 PM
  2. Replies: 4
    Last Post: 02-13-2013, 09:19 PM
  3. #Size Error
    By thedanch in forum Forms
    Replies: 12
    Last Post: 07-20-2012, 01:27 PM
  4. Field size error
    By Newbie11 in forum Forms
    Replies: 8
    Last Post: 12-26-2011, 08:15 PM
  5. After error database have less size
    By Douglasrac in forum Access
    Replies: 3
    Last Post: 03-31-2011, 07:16 PM

Tags for this Thread

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