Vanishing/truncated data on forms

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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MargaretM" wrote in message
...
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.

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.


-----Original Message-----
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MargaretM" wrote
in message
...
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.


.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...

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.


-----Original Message-----
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.


"MargaretM" wrote
in message
...
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.

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

-----Original Message-----
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MargaretM" wrote
in message
...
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.


.