New User - Please Help with text box issue...

[mayraellen]

Hi all,
I just starting to use Access so I realize this is probably an extremely easy question but I'm hoping you can help. It's been 2 days and I can't figure this out on my own...

I have created a form succesfully with the exception of one text box issue. The text box I created is very large with a scroll bar - it's for "Addtl Comments". Whenever I reach the point of entering text 5 lines down, it lets me keep entering text but when I click off the box, the text below that point always disapears. I've been playing with the formatting properties but I can't figure it out. The "can grow" proprerty is set to "yes" the "can shrink" is set to "no".

What can I do so all the text I enter below that point stays?

Thanks in advance for you help!

PS- The number of characters is only at about 100 when it cuts off... and changing it to memo doesn't work either...

 

[Brianwarnock]

A text field can only store 255 characters, if you need more use a memo type.

Brian

Edit Don't you hate it when somebody changes their post thus making yours look stupid.

PS- The number of characters is only at about 100 when it cuts off... and changing it to memo doesn't work either...

 

[mayraellen]

Thanks but I already tried that and it's giving me the same problem (??)...

 

[poporacer]

Is the textbox bound to your table? If so, check the table for the field length.

 

[Big Pat]

Yes...sounds like the field properties in your table could be the problem. I'm still a newbie so this kind of stuff is still recent to me!

Open your table in design view, select your field and check the Field Size on the General tab at the bottom of the screen (in Access 2003 at any rate)

Set that to 255, which is the maximum you can have for a text box. If that's not going to be enough, you 'll need to change the Data Type (back up the screen) to Memo.

Save and close.


Then you still need to update your form. There's probably something you can do in Properties, but the easiest way I've found is to delete the text box from your form and then drag it back on again from the Field List box. This ensures that all the properties you set in the table will match those on the form.