Vanishing/truncated data on forms

[MargaretM]

Can anyone tell me why data should truncate in a field
set to data type memo on a form. There is adequate white
space on the form so that should not be a problem and It
makes no difference if I type it or paste it.

 

[Allen Browne]

Check that there is nothing in the Format property of the text box on the
form, and nothing in the Format property of the field in table design.

Formatting (such as converting case) causes the memo to truncate at 255
characters.

 

[Guest]

Hi

If I am looking in the correct place and being a real
beginner I am by no means sure I think it says "text" in
both instances.

 

[Allen Browne]

In table design view, select the field.
Then in the lower pane, delete any entry beside the Format property.
Save. Close the table.

Then open your form in design view.
Right-click the text box, and choose Properties.
On the Format tab of the properties box, locate the Format property.
Delete anything beside this property.

 

[MargaretM]

I did nothing except set the data type to memo. I have
touched nothing else. As a total beginner I don't even
know what to mess arounf with except data types.

Margaret