472,958 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 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 2233
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,547 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: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

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.