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

Character Limit on file property value returned by getDetailsOf?

P: 63
I'm using Access/VBA to traverse a file directory and produce a table of contents, including the keywords in the files' extended properties.

I've been able to successfully do this using the getDetailsOf method of the shell.namespace.folder object. However, I've noticed that for files with lengthy keyword strings, only a part of the keyword value is returned--not the entire thing.

Does anyone know if there is a limit to the size of the value that can be returned by this method?

Jun 29 '10 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,768
I had a look for you and found BSTR (referring to the Type of the return value). I could find no indication of such a short limit. It implies a string of approximately 2GB is allowed. How this is handled within VBA and, more specifically your code, is something I don't know. It sounds like it may be cutting off at 255 chars.
Jun 29 '10 #2

P: 63
It is cutting off at 260 characters. The file is storing all the keywords, so there must not be a limit on the file system side.

Strange side note--not sure if it's signifcant: when I view a file's properties in Windows XP, on the Summary tab if it's in the "Simple" view and I click in the Keyword field and scroll over, it's cut off at 260 characters. If I then click the "Advanced" view--still only the first 260 characters show. However, if I open the properties and go to the "Advanced" view without first clicking in the Keywords field in the "Simple" view, the entire value is there.
Jun 29 '10 #3

Expert Mod 15k+
P: 31,768
Strange indeed.

Unfortunately not an area I have much experience in myself.
Jun 29 '10 #4

Post your reply

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