Problem with Save and Modify Record using DAO

  • Thread starter Thread starter Bastian
  • Start date Start date
B

Bastian

Hi,

I need help.

I have several TextBoxes in an unbound Form and try to
save the entered data into a table. The Fields in table
have Data Type Text and Size 255 ( for the TextBoxes in
the Form, I built a code that do not allow users to enter
text more than 255 characters ). If the TextBoxes filled
just with few Text ( less than 255 characters ) and saved
into the table, it work very well. But if the TextBoxes
fill with 255 characters of Text and saved into the table,
I got always this error massage '3047 Record is too large'.

I use DAO.RecordSet to Update the table.

Could somebody help me please ?!

Thank you and have a nice day.
Bastian
 
The sum of characters in all fields can't exceed around 2000.

Could you change some of these text fields to Memo instead?
Each Memo field count just 10 characters towards the size of the record,
regardless of the number of characters stored.
 
Back
Top