Unrecognized Carriage Return Character 1

[Lourry]

Hello All,

I am having this problem with my textbox's format. I have a field that stores information that a user types on a form, like extra notes that a user puts down. In Oracle, the carriage return character shows up as a square box, then when I view the records in the form that I created in Access, the information appears to be on one continuous row and where the user press "ENTER" for new line, shows up with a vertical bar character. These records are not created in Access, it was created by another program but stored in Oracle database. How can I get my Access form to read this information and display it with proper formatting?

ANy ideas? PLease help!!

Thanks a lot,
-Lory

 

[Rolliee]

The CR should be a chr(13) and recognisable as such. Search the string for chr(13)

Rollie E

 

[CajunCenturion]

That's true that Chr(13) is a carriage return, but you may also need a Chr(10) Line Feed character.

You may need to replace Chr(13) (vbCr) with Chr(13) & Chr(10) (vbCrLf) for proper display. How best to perform the replace will depend on which version of Access you're using.



Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Lourry]

Hi Thanks for the reply....

I'm using Access 97. How do I replace with Chr(13) or Chr(13) & Chr(10)?? Where do I do this? Should I be writing a code in the textbox after_Update event to search for the "vertical bar" that is showing up and replace it with Chr(13) or ??

Thanks again for the replies.

-Lory

 

[CajunCenturion]

I don't think the AfterUpdate event is the right place. I would call a public ReplaceIt function in the ControlSource, and then in a standard code module, write the Public ReplaceIt function. There are many examples of such a replace function in the forum. A keyword search should easily find one.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[CajunCenturion]

faq705-1824 has such a replace function.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Lourry]

Is the character set in Access 97 and Access 2002 differ by a lot? Because the text is appearing differently in 2002 than in 97 version. In 2002, the text is actually readable but in 97, it has many extra characters in between letters.

Can I fix this?

Thanks in advance!

 

[CajunCenturion]

That is strange. Is there any chance that you can capture a screen shot, and post it to the forum as an image?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Lourry]

Yes, I can try....

How do I attach files in this forum??

 

[CajunCenturion]

Click on the "Process TGML" link at the bottom of the posting box, and you will get a popup of all of the TGML commands. Search through them until you find the [ignore][/ignore] tag and the details on how to use it.

Good Luck
--------------
[i]As a circle of light increases so does the circumference of darkness around it. - Albert Einstein[/i]

 

[Lourry]

um...I'm having trouble posting the image.

Well...here's a replica of it that I tried to just type out.

The Access 97 on WinNT version:
t|e|s|t|t|e|s|t| |t|e|s|t| |t|e|s|t|||t|e|s|t|

The Access 2002 on Win 2K version:
testtest test test|test

What it is suppose to look like:
testtest test test
test

The field in Oracle has datatype "LONG" and in Access it is mapped to "MEMO". When I copy that vertical bar in Access 2002 to notepad, it turns up to be a square.

Please help. Thanks!

 

[CajunCenturion]

Looks like two issues are in play. The one bar that shows on the A2K2 version appears to be either a Line Feed [chr(10)], or a Carriage Return [chr(13)] character, either of which needs to be replaced with both characters [chr(13) & chr(10)], or using the VBA symbolic constant vbCrLf. We talked about the replace above. If you are already replacing the CR with CRLF, then change that to replace the LF with CRLF and see what happens.

As to A97 display, my first inclination is that the text in Oracle is stored in Unicode characters (2 bytes per character) and A97 doesn't know how to handle Unicode, whereas A2K2 does. I'm not sure how in A97 to even test that supposition, and I don't have an A97 system to even try. Hopefully someone else has dealt with Unicode in the A97 environment.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Lourry]

Anyone know how to deal with Unicode in Access 97 environment?

Please help. Thanks!

 

[hymn]

Just did a search on Google
Access 97/2000: Tables... is bigger because UNICODE takes up more space; and 2) Access 97 cannot read full-fledged Access 2000 databases because Access 97 doesn¹t understand UNICODE. ...

http://www.umbc.edu/oit/newmedia/

training/documents/Tables/tables.html - 32k - Cached - Similar pages

Sorry about that


Hope this helps
Hymn

 

[Lourry]

Thanks Hymn! Your article is very informative.

Since we still have Access 97 as the company standard, is there a way to convert the data from UNICODE to ASCII in my Oracle database table??

Thanks again for all the help!

 

[CajunCenturion]

You might have better success Lourry posting that question in one of the Oracle fora, of which this site has many. In the upper left hand corner of each page is a list of links underneath your handle. Click on "Forum List", search that page for "Oracle", and pick the forum that most closely matches your situation.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[CajunCenturion]

Please let us know how this turns out. All of the folks here volunteer their time to try to help and sure appreciate knowing if their efforts were not in vain, or even to learn from some mistakes. Getting, help, and in turn giving help to others, is what this site is all about.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Lourry]

Yes, I was actually going to post the solution here as well once this problem is solved but it is still in the process.

For anyone that is interested, you can go here to see my post in the Oracle Forum.

Thanks again to all that replied to this post!