Susan Geller
sgeller at cce.umn.edu
Thu Jul 24 11:46:03 CDT 2003
John, Do you know the constant for single tick and double tick? I am using CHR and I agree that is not as good as constants. Where can I find a complete list of constants? --Susan -----Original Message----- From: jcolby at colbyconsulting.com [mailto:jcolby at colbyconsulting.com] Sent: Wednesday, July 23, 2003 8:11 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Displaying TAB as [Chr(9)] in a text control 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com