Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

data types string

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

Data Types - String

ResolvedVersion 2007

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

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

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 courses

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:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.