Wortz, Charles
CWortz at tea.state.tx.us
Wed Jul 23 08:27:42 CDT 2003
David, I think your problem is due to the fact that text fields within Access reports do not support tab settings. In the RTF document tab settings are recognized so during the formatting event the tab character acts as a formatting command that executes a macro that generates enough white space to get the next character to print at the position of the next tab stop. Since there are no tab stops within Access report text fields, the tab character is not treated as a formatting command but rather as an unprintable character. The vbCRLF is about the only formatting character that is recognized inside Access report text fields. I hope that answers your question as to why. Sorry, but I cannot give you an answer as to how to get around this. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: jcolby at colbyconsulting.com [mailto:jcolby at colbyconsulting.com] Sent: Wednesday 2003 Jul 23 08:11 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