-
When saving away a blank textbox's contents to an ms Access db i get the following error message.
"Multistep operation generated error, Check each status"
I have checked the field type on the db and it is 'Text' and has the 'Allow Zero Length' property set to true and 'Required' set to flase.
This error seems to be intermitent
Please Help
Any solutions or ideas would be greatfully appreciated
Jamie
-
<?>
'Convert NULL Values to Empty Strings to Avoid Errors
'One way to avoid errors from occurring when retrieving NULL values from a recordset object is to inspect the field's value.
'If it is NULL, then convert it to an empty string or zero. For example:
If isnull(rs("Field")) then tmp="" else tmp=rs("Field") form.textfield=tmp
'An even simpler way is to use the format function, which will convert a NULL value to an empty string automatically, avoiding any error messages.
'It will look like this:
form.textfield=format(rs("Field"))