jcolby at colbyconsulting.com
jcolby at colbyconsulting.com
Wed Jul 23 08:10:40 CDT 2003
I can't help you directly with that however I do recommend that you replace the rather cryptic chr(x) with the constants (which are readable in English) vbCRLF, vbTab etc. Just better programming style. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Fenton Sent: Wednesday, July 23, 2003 8:11 AM To: accessd at databaseadvisors.com Subject: [AccessD] Displaying TAB as [Chr(9)] in a text control Does anyone know what to do about the little square that appears when using TAB (ASCII 9) in a textbox on a report? If I direct the report to a RTF document the tab translates perfectly to a TAB as itis supposed to, but it will not do it on the report in its natural form. Below is the code Iam using in the text control. ="Student No:" & Chr(9) & [StudID] & Chr(13) & Chr(10) & "Course: " & Chr(9) & IIf([CourseName] Is Null,[CRICOS_name],[CourseName]) Cheers David Ô¿Ô¬ Australia _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com