Results 1 to 6 of 6
  1. #1
    bradp1979 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jul 2015
    Location
    San Francisco, CA
    Posts
    234

    Numbers turning to number signs


    Hi all, the picture below is of a printable report that my office generates regularly. Out of nowhere, it started giving "##" instead of 2-digit numbers in the far-left column, and "########" instead of a 4-digit time such as "12:30 PM"

    I've tried increasing the width of the boxes that the numbers sit in, but I think I need to instead increase the width of the column. I can't figure out how to do that though; I don't see the option in the 'properties' area.

    Click image for larger version. 

Name:	SERS.png 
Views:	4 
Size:	64.3 KB 
ID:	22069

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Increasing textbox width should accommodate the content. What do you mean by 'width of the column'? What changes have taken place that could have altered the report output?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    bradp1979 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jul 2015
    Location
    San Francisco, CA
    Posts
    234
    I don't know. I altered a few things on the report, but nothing with the textboxes in question. The alterations I made were just changing a few words at the top of the page.

    Just to test it out, I increased the size of the textbox to the entire width of the page, and still got the "##" for a 2-digit number.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Would have to examine report design. If you want to provide, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    bradp1979 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jul 2015
    Location
    San Francisco, CA
    Posts
    234
    Might you still have it from the other times I sent it? My DB elicits the response: "Oh drat, THAT db!"

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Sorry, it's gone. I discard downloads when done with thread.

    Give me link to other thread that has it and I will download again. But if it doesn't have the issue, what would I analyze?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 09-02-2015, 03:01 PM
  2. Find First number in sequence of numbers
    By losstww in forum Queries
    Replies: 4
    Last Post: 11-16-2012, 02:44 PM
  3. Replies: 9
    Last Post: 11-04-2012, 10:46 PM
  4. Auto number 13 numbers
    By dmaddox in forum Access
    Replies: 10
    Last Post: 05-23-2012, 12:34 PM
  5. Getting rid of ### signs
    By Lorlai in forum Access
    Replies: 6
    Last Post: 07-27-2011, 01:29 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