Results 1 to 3 of 3
  1. #1
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596

    VBA - Text File: Is there such a thing as a 'New Page' character?

    I have never heard of a NewPage character with reference to text files.
    I have VBA that creates a text file.
    After 65 lines are written to the file - my VBA writes out a blank line and 4 PageHeader lines.
    Is there such a thing as a 'NewPage' character that I can put in the blank line that comes just before the 4 PageHeader lines?
    Or . . . is there an alternative to the 'NewPage' character?



    The text file will get written to the network and then uploaded [using a program that I do not control] into a 3rd party reporting software [Synergy].
    The person whose program will upload the text file asked me to find out if it is possible to add a NewPage character in every 66th line of my output text file.

    I'd appreciate any suggestions.

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    I was Googling 'ms access vba new page' . . .
    I changed my Google search to 'new page character ascii' . . . and came up with NP (New Page) . . . & FF (Form Feed).

  3. #3
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    P.S. I used vbFormFeed

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

Similar Threads

  1. Add character's to text box
    By Joopster in forum Forms
    Replies: 1
    Last Post: 03-20-2013, 06:45 PM
  2. Replies: 2
    Last Post: 02-06-2013, 09:19 PM
  3. Replies: 3
    Last Post: 12-22-2012, 05:33 PM
  4. Automated Character Count for Text Box
    By gopherking in forum Forms
    Replies: 3
    Last Post: 09-23-2011, 12:21 PM
  5. Text Box control and character limit?
    By Bigdoggit in forum Forms
    Replies: 2
    Last Post: 03-29-2011, 10:05 AM

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