Text Highlighting Issues

[lespritdelescalier]

[SOLVED] Text Highlighting Issues

Hi everyone,

I have a weird issue, and I'm not sure what to search for, so I apologize if the answer has already been discussed. I'll try to explain my issue as briefly as possible.

We have a bunch of notes that are stored in a database. The program looks for the notes that are relevant to each order, and it adds them one by one to a textbox.

In some instances, when highlighting the notes (as certain parts of them are copied by the user) it appears that you are highlighting the correct text, but when the text is copied and pasted, different text was copied to the clipboard (usually a string that is offset a couple characters).

I can't post an image (I haven't posted enough), but highlighting everything in the text box selects what appears to be blank space. I wish I could show you. Maybe I'll get to the needed number of posts and be able to attach the screencap.

I'm trying to figure out why this is happening, and how I can resolve it. It's not happening with every order, which makes be believe that the content of certain notes is causing the highlighting to freak out somehow.

Hopefully what I'm saying makes sense. If anyone has any questions, I'll do my best to answer them.

Thank you!

 

[vbaInet]

Have you identified which notes it consistently happens on?

 

[lespritdelescalier]

No, I haven't. The notes don't have to be copied often, but I tried five examples where they do have to be copied, and I was only able to reproduce the issue once. I checked the notes for special characters or something that might be causing some irregularity, but I wasn't able to find anything out of the ordinary.

 

[vbaInet]

Ok. Did you consistently reproduce the error on that one note?

And where are the notes copied from?

 

[lespritdelescalier]

Well, I consistently reproduced the error on the one order. I can try pulling the notes individually (currently the program loops and doesn't stop until they are all loaded).

The notes are loaded from and Oracle db, and appended to the text box using VBA. When something needs to be copied from the text box, it is usually pasted into another part of the Access program.

 

[vbaInet]

I've not had this problem with an Oracle db before. Do you know what the datatype of that field is in the Oracle db?

Cut the problem note from your Access table, paste it into Notepad, copy from Notepad and paste back into the table and re-test. If the problem still persists, paste it into a new table and test it with that.

 

[lespritdelescalier]

I've not had this problem with an Oracle db before. Do you know what the datatype of that field is in the Oracle db?

Cut the problem note from your Access table, paste it into Notepad, copy from Notepad and paste back into the table and re-test. If the problem still persists, paste it into a new table and test it with that.

Hey, I just wanted to say thanks, and let you know that I was able to figure it out this morning. the VBA was inserting an ASCII carriage return in after every note that started causing an issue. I suspect that this started happening when we upgraded our systems from WinXP to Win7. I apologize that I didn't mention that we upgraded, as it hadn't even crossed my mind until this morning.

Have a good day!

 

[vbaInet]

That's interesting, but it shouldn't have caused the highlighting issue.

Glad you got it sorted!