Results 1 to 6 of 6
  1. #1
    Hasher is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Posts
    13

    New line annoyance

    Hi all



    So I'm sure this has been asked before and I probably am not searching for the right solution. I have a form where I enter new lines. When I do it trails with a zero '0' . How do I stop it from doing this ? Attached is a picture of the problem. It was meant to have 1 and 2. But it appends a '0' to the end. How to get around this ? Thanks in advance !

    Click image for larger version. 

Name:	Untitled.png 
Views:	18 
Size:	7.1 KB 
ID:	19044

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Hmm...what is the field type of the field?

  3. #3
    Hasher is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Posts
    13
    ItemNo field is a number (Double)

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Any chance you could zip up your db and attach it to a post?

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    This is such a strange sounding glitch that I'm posting mainly so that I can follow it!

    Assuming that you haven't done something to bring about this behavior (and subsequently forgotten that you did it, which we've all done!) my only guess, at this point, would be that the Control, itself, is corrupted. The test/fix for this would be to delete the Textbox and re-create it.

    Barring that, we really need to get our hands on your file, as Allan requested.

    Linq ;0)>

  6. #6
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    India
    Posts
    616
    The issue can be replicated if the text box is formatted as 0\0. The trailing 0 appears after exiting the text box.Not sure if this applies here.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-11-2014, 03:54 PM
  2. Replies: 10
    Last Post: 06-10-2014, 09:03 AM
  3. Line by Line Transactional Data Queries
    By defaultuser909 in forum Queries
    Replies: 7
    Last Post: 07-18-2012, 10:00 AM
  4. Access to Excel 2007 export annoyance
    By jim wv in forum Import/Export Data
    Replies: 3
    Last Post: 10-14-2011, 09:48 AM
  5. Replies: 7
    Last Post: 04-11-2011, 03:58 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