I have a group of textboxes bound to several fields in an Access 97 table
using ADO in VB 6 on win9x machines. The textboxes are using the standard
percent format ("0%" format string). They work fine until the user tries to
change the values in the textboxes. When it goes to update we get the
'The change was canceled during notification; no columns are changed'
run-time error. If I remove the formatting we can change and update the new
values just fine but we would really like to have the data formatted  if
possible. Anyone know what I'm doing wrong?

Chris Lande
Pyromation Inc.

1st question is, have you updated to the latest service pack?
2nd Question, why are you linking text boxes to data fields? This is a real
sticky wicket. Use code rather than a data control. Data Controls can cause
more problems than they resolve.
And beware of ADO it isn't fully functional yet and not totally supported by
MS, as is mentioned in certain books and journals.

--
VB Code Samples
http://www.tigerbites.com/