98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Data Types - String
Data Types - String
Resolved · Low Priority · Version 2007
Tue 19 Jul 2011, 10:48Delegate Craig said...
Craig has attended:
Access VBA course
Data Types - String
Good Morning.
There appears to be two types of string, variable and fixed length. How do we define between the two, as defining a dimension ' As String' appears to give me fixed length and limit me to 65,000 characters.
Also, I would like to say thanks again for a great course and if a certificate could possible be sent out to me in due course it would be much appreciated.
Many Thanks,
Craig
Fri 22 Jul 2011, 12:28Trainer Anthony said...
RE: Data Types - String
Hi Craig, thanks for your query and the feedback. There's a useful walkthrough of string sizing here:
http://www.cpearson.com/excel/SizeString.htm
Hope this helps,
Anthony
Fri 22 Jul 2011, 12:46Trainer Yolande said...
RE: Data Types - String
Hi
Thanks for your certificate request, we've printed one off and it will be sent to you within a week.
Best regards
Yolande
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |
