limited field size? text is cut off max of 50 char

[Chazper]

I've created a form using the data form wizard connecting to a .mdb

Problem: I can't store more than 50 characters in fields of a .mdb

Action taken:
I've set the size of the field = 255

When I input the value directly on ms access, it accepts 255 characters... and can be viewed in the form. But when i use the form created by the wizard to input text, it can only store 50 characters on the field. Even though i've typed in more than 50 characters in the binded textbox...

Can anyone tell me what i need to know or point me to a site where I could find a solution? I tried to search thru' this forum, and found other people who also experienced this problem but no solution was discussed.

 

[Chazper]

This is embarassing! I tried RECONFIGURING my auto generated data adapter and my problem was solved!
I should have thought of this in the first place! Since I modified the field size to 255 from 50 of the fields in my .mdb, I should have also reconfigured my auto generated data adapter.

Kindly close this thread... it's embarassing. Someone hit me in the head!

 

[cjard]

i was going to tell you that you had:

database field size 50
generated a datatable for this (datatable field size is 50)
resized database to 255
wondering why your 255 textbox, bound to your 50-wide datatable field, into your 255-wide database is limiting to 50 chars?


it's the datatable design...

dont forget when you make any db changes, to update the datatables design too. that includes PK, contraints, datatypes, names.. anything