Increasing number of characters in text box

[bentley7]

I'm trying to increase the number of characters to greater than 255 in a text box. I have changed the field's data type to "memo", but that is not helping the issue. It is still truncating at 255 characters.

Any help would be appreciated.

 

[DCrake]

Simple Software Solutions

Please explain the senario so that a more constructive response can be made.

Such as where is the large text coming from?

CodeMaster:

 

[bentley7]

The text is stored in a table and it is looking it up. I would like it to just appear "as is" on the form, with no manipulation occuring to it at any point. I tried changing the data type on that table from text to memo, and that is not fixing the problem. I am still unable to view more than 255 characters.

 

[wiklendt]

i had a similar problem at one point. someone suggested that listboxes and comboboxes are unable to store more than 255 characters, even if the list/combo is sourced from a memo field.

the solution would be to clone the recordset

and perhaps make the combo a shorter item name for the longer text (e.g., a field called 'tax' and 'description' - your description would be your >255 char text, and the 'tax' would be your PK that you'd search for the text by) you can then use the combo to find the record, and have the text appear in a text box (which can handle 255+ chars)....

don't quote me on all this, though... i'm relatively new to access. i'd say, however, you may ned to rethink how you are organising your data entry...

 

[suepowell]

I would try deleting the field on the form, then putting it back on.

The control on the form may be remembering the previous parameters, and redoing it might well solve the problem.

I recently spent a couple of hours trying to do what I had done loads of time before with no problem. It just wouldn't behave, so copied all controls to a new form and everythjing was fine. Access sometimes get's it knickers in a twist for no apparent reason so sometimes the quickest way is just to redo the form.

Good luck

Sue