By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

String functions

P: 29
what does the String(long, char*) funciton do?

i can't seem to find an explination on the web. from the code i'm looking at, it appears to return a string of (value of long) of (value of char*) characters. is that true?

what's the differetnce between String(.. and String$(...

??
Dec 20 '06 #1
Share this Question
Share on Google+
4 Replies


missinglinq
Expert 2.5K+
P: 3,532
There is no difference. Before going to the web, or posting here or on another forum, it's always a good idea to try Access' Help first. If you then have questions we're always happy to help. This is straight from Help:
String Function
Returns a Variant (String) containing a repeating character string of the length specified.

String(number, character)

MyString = String(5, "*") ' Returns "*****".
MyString = String(5, 42) ' Returns "*****".
MyString = String(5, "ABC") ' Returns "AAAAA".
Dec 20 '06 #2

P: 29
There is no difference. Before going to the web, or posting here or on another forum, it's always a good idea to try Access' Help first. If you then have questions we're always happy to help. This is straight from Help:
thank you.

i tried the access help, couldn't find anything on the string function. that's why i went to the web, and here.

thanks though.
Dec 20 '06 #3

missinglinq
Expert 2.5K+
P: 3,532
Help in Access is context oriented, which is to say it only applies to the part of Access you're in when you invoke it. Since String is a function used in VBA code, you have to be in the VB Editor then enter "string" in Help to pull up the help file. Doing the same thing from the Objects Dialog box or from Design View won't bring help up on this subject.
Dec 20 '06 #4

ADezii
Expert 5K+
P: 8,669
what does the String(long, char*) funciton do?

i can't seem to find an explination on the web. from the code i'm looking at, it appears to return a string of (value of long) of (value of char*) characters. is that true?

what's the differetnce between String(.. and String$(...

??
String(number, character) returns a Variant of Sub-Type String
String$(number, character) returns a String

'Use the String$ version whenever possible to avoid the overhead of dealing
'with the Variant data type
Dec 20 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.