validate data length

T

Toxalot

I'm using VBA/ADO. I'm using a disconnected recordset.

When the user makes changes or adds a new record, I want to validate
the data before updating the database.

I would like to make sure that none of the data is too large for the
fields they'll be stored in. What is the best way to do this?

Jennifer
 
R

RoyVidar

Toxalot said:
I'm using VBA/ADO. I'm using a disconnected recordset.

When the user makes changes or adds a new record, I want to validate
the data before updating the database.

I would like to make sure that none of the data is too large for the
fields they'll be stored in. What is the best way to do this?

Jennifer
Click to expand...

I would probably use the field size property of the table, and use
bound forms.

In these groups, you will probably also get the advice of using DAO
as means of programmatic access to the information and structure.
 
Top