gary.newport
Registered User.
- Local time
- Today, 01:51
- Joined
- Oct 14, 2009
- Messages
- 79
I have looked on the web and found this raised a couple of times but the solutions are not working for me.
I am using Access 2010 and have a form based upon a query (qry_student). In tihs query I have a field called Details that contains the student's address; a composite of the relevant fields from the table tbl_student. I have used chr(13) & chr(10) to create linebreaks wihtin the query field.
I have a textbox where the Control Source is set to this field of the query.
The textbox does not display the data correct and I believe this is because it is in Plain Text mode.
When I try to change it to Rich Text I get an error message.
If I remove the control source then I can change it to Rich Text but then this negates the very purpose of the textbox.
Any ideas?
I am using Access 2010 and have a form based upon a query (qry_student). In tihs query I have a field called Details that contains the student's address; a composite of the relevant fields from the table tbl_student. I have used chr(13) & chr(10) to create linebreaks wihtin the query field.
I have a textbox where the Control Source is set to this field of the query.
The textbox does not display the data correct and I believe this is because it is in Plain Text mode.
When I try to change it to Rich Text I get an error message.
If I remove the control source then I can change it to Rich Text but then this negates the very purpose of the textbox.
Any ideas?
