need vb / access help

[DavidRidgway]

Programming Language: VB 6.0
Database Program: Access 97
Control: Masked Edit Box
Field: Date
Mask: "##/##/####"
Data Control: ADO (ActiveX Data Objects)

This control is part of a control array. (Datefield(6))
All the other fields in the control array (Datefield(0) to Datefield(5)) work fine, it is just the last one.

I get the following message when the data control is assigned the database and recordsource in code.

"Field not updateable, Bound Property Name: Text, Field Name: date employment ended"

I get the following message when the data control is directly linked to the table via the properties window.

"Unable to bind to field or data member: date employment ended"

can anyone please help me.....thanks

[Clunietp]

ah, the fun of bound controls. I've had this before, I had to do a manual update on that field. You could also bind a standard textbox to your database and when the contents of the masked control changes, put the value into that hidden text field (be sure you don't bind the masked edit control)

[Mongo]

Make sure you set the DataField property of the textbox to Empty prior to resetting the DataSource and the DataField.

If that doesn't help and it's not too much trouble, try renaming [date employment ended] field to something more "oldtimer -- when every byte counted" like [dt_emp_end] because 16-bit legacy, still lurks around.

Hope this helps