I'm creating a VB front end to an Access 2002 DB.
So far I have been using ADO to execute SQL statements against the Access DB.
I'm now trying to limit the length of text a user can enter in a textbox. I would like the textxbox maximum length to match the field size of the corresponding Access DB field. I thought I would use the COL_LENGTH SQL statement, but whenever I try this, I get the following error message:
"Undefined function 'COL_LENGTH' in expression"
I have been looking for a workaround. Any suggestions?