B
B. Meincke
If this is more appropriately asked as a "form design" forum question, my
apologies up front...
My problem is having an unbound form's macro to save records fail for some
records and not others...on some workstations and not others...by some users
and not others.
The only common denominator I can come up with is the failures seem to be on
records that contain lengthy comments entered into a textbox field that is
bound to a memo filed in an underlying table.
My research tells me that both the textbox filed and the memo field can
handle waaayyyy more than the three or four hundred characters customary to
teacher comments (especially those prolific English teachers!!! <G>).
In Access 2000, is there a bug that I am unaware of that would cause such
behaviour? Is there a limitation beyond the 65,000 characters I read about?
Thanks in advance for any insight.
apologies up front...
My problem is having an unbound form's macro to save records fail for some
records and not others...on some workstations and not others...by some users
and not others.
The only common denominator I can come up with is the failures seem to be on
records that contain lengthy comments entered into a textbox field that is
bound to a memo filed in an underlying table.
My research tells me that both the textbox filed and the memo field can
handle waaayyyy more than the three or four hundred characters customary to
teacher comments (especially those prolific English teachers!!! <G>).
In Access 2000, is there a bug that I am unaware of that would cause such
behaviour? Is there a limitation beyond the 65,000 characters I read about?
Thanks in advance for any insight.