Hello, I have a question about using a richtextbox in an access report.
I have a VB6 program that uses an Access database for data storage and for reports. In the VB program, I am taking the input of two strings to build a string in a richtextbox. The reason I am doing this is because the string is much easier to view if I can add in subscripts and italics - I've learned this is only possible in a richtextbox and not a standard textbox.
(FYI the string contains a listing of DNA and/or RNA, a simple form to write it is ACGAGT but that doesn't tell you what the sequence actually is. So alternatively you could write d(A)d(C)r(G)r(A)r(G)r(T) the r and d indicate RNA or DNA. Also, there are linkages such as p and s. The string becomes d(As)d(Cp)r(Gs)... With a richtextbox I put the d and r in italics and the p and s in subscript and it views nicely.)
So, in the VB program the sequence looks great, very readable. Now I am trying to get this to print in an Access report! I have no problem getting data from the VB app to an Access report. The problem is getting this richtextbox into the report. I have added a richtextbox activex control into my report but it doesn't display anything even if I set the text to any text. Ultimately, I wanted to 'build' my richtextbox string in the onformat routine on the detail seciton of my report from the same two strings I used in the VB program.
Any ideas? Have I made it clear what it is I am trying to do?
Thanks for any help.
Gerry Dyck
