[AccessD] RE: Using Constants

Go to the object browser and type "constants" into the search dropdown.  Then select Constants for Access or VB or whatever to see the built in constants for that library.

Charlotte Foust

-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu] 
Sent: Thursday, July 24, 2003 8:46 AM
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