255+ Characters (1 Viewer)

[Ukraine82]

Can I make a text box with more than 255 characters? I'm pretty sure the answer is no. I thought maybe there's a vb code for it.

The way I did it was I made 2 text boxes and put them close to each other so it looks like 1 text box (Form View).

The only bad thing about it is that sometimes the sentence it not finish and it goes to next text box.

Michael

 

[Mile-O]

Can I make a text box with more than 255 characters? I'm pretty sure the answer is no. I thought maybe there's a vb code for it.

A textbox can hold loads more than 255 characters. You may have the textbox bound to a Text field (limited to 255 characters) instead of a Memo field.

 

[freddienet]

Reports for text (memo field)

Make sure when you use the memo field, on your reports, you set the properties to can grow. This way the memo field when displayed will show all text.

Freddie

new guy
Hey from Ohio

 

[Ukraine82]

I was going to use the memo, but I got some of my field2 text box filled out already. If I delete field2 text and overwrite my field1 from text to memo.

I'm losing my work from field2. It not that bad I mean I only have 14 records that people typed in field2 text. I might as well copy all my field2 text and paste it to field1 memo.

I just thought it would be easier with code instead of coping and pasting.

Michael

 

[ghudson]

use an update query to copy the data in the text fields to the memo fields. then delete the text fields and rename the memo fields if needed.