data types string
Request a callback

We'll call during UK business hours

0207 987 3777

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



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

Training courses
London & UK

Live dates & prices »

On-site training

Get a quote »


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.

Excel training
Course rating
4.7 stars - based on 26179 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom