Limitation to textboxes on a form

[Iain Anderson]

Hi guys,
I haven't been able to find if there is a maximum length of text within a textbox.

I have a form on a club database, and one of the textboxes has the details of their photographic experience. I have one person who is a very experienced worker and I need to add more details in the textbox. Currently there are 29 characters, including spaces in the box, but it won't allow me to add any more. I have set the width of the box on the form to a wider setting, but this makes no difference.
What can I do?

Regards,
Iain Anderson

 

[Eljefegeneo]

Your table must be limiting the number of characters. A text box can have 255 characters. A memo field can have over 65K. Change it in the table.

 

[Iain Anderson]

If I change it to a memo field, will I lose all the information that is already held in those textboxes?

Iain

 

[Uncle Gizmo]

Make a backup and then try it!

 

[Eljefegeneo]

I was going to make that same suggestion, but of course coming from Uncle G validates my suggestion.

And as a further suggestion, make a backup copy of your DB, and then try new things. If they work fine; if they don't go back to the backup version. That is how I learned to do many new things with Access. Lots of mistakes and lots of successes!

 

[Uncle Gizmo]

Lots of mistakes and lots of successes!

That's how you get better at it!

I recall many years ago using a spreadsheet in a DOS system. When I navigated across the screen instead of the cursor moving from cell to cell the screen moved block by block. There were no Internet forums to ask and everyone I asked was just as puzzled as I. I looked through the help files I did everything I could think of. After a couple of days of scratching my head, I realised it was because I had a button pressed on keyboard! One solitry button Keyed in the wrong position!