[AccessD] Displaying TAB as [Chr(9)] in a text control

As others have pointed out, the native Access textbox does not support tabs
or other special characters. In your case you could try replacing Chr(9)
with String(4," ") to get four (or whatever number you want) spaces inserted
into the textbox.

Lambert

> -----Original Message-----
> From:	David Fenton [SMTP:dfenton at ozemail.com.au]
> 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