VB Forum / General 2 / April 2004

Dear all,

Hope you can help me with my current situation:

I am loading 3 fields (EmpID, TFA, PRSI) from a table (Tax Free Allowance)
in Access to a DataGrid on a form in VB6.

It's allowing me to update the data in the DataGrid (DataGridTax) to the
table in Access but i need to perform some sort of validation. On the TFA
and PRSI fields, i want to check if TFA field is Currency/Numeric and PRSI
is numeric. And if not, display an approprate error message.

Would it be best to do this in Visual Basic 6 or in Access? And how?

Brian