[AccessD] RE: Using Constants

I got some constants (Keycode and MsgBox contants only) from Access 97 Help a while back  ...  will see if I can rustle up the Word doc and send off-line.

Stephen Bond

-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu]
Sent: Friday, 25 July 2003 4:46 a.m.
To: Access Developers discussion and problem solving
Subject: [AccessD] RE: Using Constants


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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com