*RESOLVED* Variables returned from a Class Property & Database

[Kinsy]

Made a post last week before i left work, but its dissapeared.

Im using a Class module to call up a Open File dialog and copy the address selected to a variable. This is in Access VB.

The user picks a jpg file, presses ok and a msgbox pops up with the path. This seems ok.

However, when i put the Class property variable into a normal variable, and then subsequently into the data field, it gives me data too large.

Code:-

strImagePath = cdlg.GetName
Me.SurveyImageLocation = strImagePath

Just had a quick look at a file with a short path so that i could see if there was anything at the end of the path, and there seems to be a LOT of SQUARE BOX - like characters that almost look like spaces!

Is there a way i can clean these up? This would probably fix it. Perhaps putting a limit on the string variable's characters would do it, or preferrably, some code that strips any characters at the end of the path.