473,396 Members | 1,767 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Reading page breaks

I am trying to create a form that allows users to paste information (a full adress) from an other application (xml based ) into an access 97 text box - then use vba code to split the string into substrings and copy them to other text boxes using the (existing) page breaks that are in the text string but unfortunately i cannot work out how to refer to the breaks in code, they do show up as double square characters if I pass the text to a string but I cannot work out how to refer to these breaks any Ideas?
Jul 15 '07 #1
2 2249
puppydogbuddy
1,923 Expert 1GB
I am trying to create a form that allows users to paste information (a full adress) from an other application (xml based ) into an access 97 text box - then use vba code to split the string into substrings and copy them to other text boxes using the (existing) page breaks that are in the text string but unfortunately i cannot work out how to refer to the breaks in code, they do show up as double square characters if I pass the text to a string but I cannot work out how to refer to these breaks any Ideas?

Try the search and replace using the ascii code....... Chr(12) is the ascii code for page break
Jul 15 '07 #2
NeoPa
32,556 Expert Mod 16PB
I am trying to create a form that allows users to paste information (a full adress) from an other application (xml based ) into an access 97 text box - then use vba code to split the string into substrings and copy them to other text boxes using the (existing) page breaks that are in the text string but unfortunately i cannot work out how to refer to the breaks in code, they do show up as double square characters if I pass the text to a string but I cannot work out how to refer to these breaks any Ideas?
As you say they are double square brackets, I assume that they are actually new line codes rather than page-break codes. A new line is actually (on PCs anyway) a Carriage Return / Line Feed sequence. In VBA this can most easily be referred to using the predefined value vbCRLF. Of course it may well be a Form Feed character, in which case a Chr(12) (or vbFormFeed) would match it for you.
Expand|Select|Wrap|Line Numbers
  1. Decimal Hexadecimal VBA code    Description
  2.   10      &H0A      vbLF        Line Feed
  3.   13      &H0D      vbCR        Carriage Return
  4.                     vbCRLF      Carriage Return / Line Feed
  5.   12      &H0C      vbFormFeed  Form Feed
Jul 15 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Christopher Glaeser | last post by:
Consider the code: $arrText = file ("http://www.site.com/page.htm"); for ($i=0; $i<count($arrText); i++) { echo("$arrText\n"); } (I did not test the snippet for errors) The line breaks...
4
by: Xah Lee | last post by:
# -*- coding: utf-8 -*- # Python # to open a file and write to file # do f=open('xfile.txt','w') # this creates a file "object" and name it f. # the second argument of open can be
1
by: Scott | last post by:
Was not sure if this was the place to post this or not, so if not, can someone point me in the right direction. Here is my problem - I have an ASP page the is generating a file with HTML that is...
4
by: nightflyer | last post by:
Hi all, [code snippet appended at the end.) my question: A class has a few string variables with not know length at design time. Now I declare lets say a 1000 of those classes and put them...
2
by: darrel | last post by:
We have a bunch of usercontrols we are using on our site. One of them calls functions in a compiled DLL (is that a 'resource' in VS.net terminology?) The pages that contains all of these controls...
1
by: kaosyeti | last post by:
hey... i have a report that groups on salespeople. the report footer is a three part summary of the store's total data with 2 different departments for parts 1 and 2 and a store total for part 3. ...
5
by: Jens | last post by:
Posted to: comp.periphs.printers comp.lang.c comp.lang.postscript Hello, I am looking for some publically available methods/algorithms or C source code for detecting
0
by: bblue | last post by:
hi, I need help in implementing page breaks in XML files? any suggestion on how can this be done? do you recommend using processing instructions or add a new elements would make more sense? can the...
5
by: Andreas Prilop | last post by:
Firefox 3 (like older versions) ignores TR { page-break-before: always } for the first row of a TBODY. Sample page: http://www.unics.uni-hannover.de/nhtcapri/temp/1000.html Choose "Print...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.