dao recordset error trapping

I have a dao recordset which I update with the following code:

With rsOrderShip
.Edit
!CustCode = frmOrders.txtSTCustCode.Text
!stcustname = frmOrders.txtSTCustName.Text
!staddress1 = frmOrders.txtSTAddress1.Text
!staddress2 = frmOrders.txtSTAddress2.Text
!stcity = frmOrders.txtSTCity.Text
!ststate = frmOrders.txtSTState.Text
!stzip = frmOrders.txtSTZip.Text
!Phone = frmOrders.txtSTPhone.Text
!Email = frmOrders.txtSTEmail.Text
.Update
End With

If a user does something like enter a text string that's too long for the
field, is there any way to get the name of the field where the error occured
(short of doing something like set a variable to the name of the field
before you try to update it). Thanks in advance.

Nothing automatic. You'll have to do it yourself, I'm afraid.

However, it's usually a good idea to perform checks like that before trying
to write to the database anyhow.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"James Houston" wrote in message

>I have a dao recordset which I update with the following code:
>
> With rsOrderShip
> .Edit
> !CustCode = frmOrders.txtSTCustCode.Text
> !stcustname = frmOrders.txtSTCustName.Text
> !staddress1 = frmOrders.txtSTAddress1.Text
> !staddress2 = frmOrders.txtSTAddress2.Text
> !stcity = frmOrders.txtSTCity.Text
> !ststate = frmOrders.txtSTState.Text
> !stzip = frmOrders.txtSTZip.Text
> !Phone = frmOrders.txtSTPhone.Text
> !Email = frmOrders.txtSTEmail.Text
> .Update
> End With
>
> If a user does something like enter a text string that's too long for the
> field, is there any way to get the name of the field where the error
> occured (short of doing something like set a variable to the name of the
> field before you try to update it). Thanks in advance.
>