data types string


starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Data Types - String

Data Types - String

resolvedResolved · Low Priority · Version 2007

Tue 19 Jul 2011, 10:48 replyReply Delegate 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,


For upcoming training course dates see: Pricing & availability

Fri 22 Jul 2011, 12:28 replyReply Trainer Anthony said...

RE: Data Types - String

Hi Craig, thanks for your query and the feedback. There's a useful walkthrough of string sizing here:

Hope this helps,


Fri 22 Jul 2011, 12:46 replyReply Trainer Yolande said...

RE: Data Types - String


Thanks for your certificate request, we've printed one off and it will be sent to you within a week.

Best regards



Live dates & prices


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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips