Text Format

[JamesJ]

I created a memo field for general notes and found that after placing it on
a form
I was unable to have the text formatted in Rich Text even though the field's
Text Format property in the table was set to Rich Text. I found that at the
form
level this same property was set to Plain Text.
Why does the field at the table level default to Rich Text and the field on
the
form default to Plain Text????

James

 

[Allen Browne]

Access can get confused if you alter the property in the table after you've
created the form.

If you can't get it sorted out, try these steps:

1. Make sure Name AutoCorrect is off:
http://allenbrowne.com/bug-03.html

2. Delete the text box from the form. Save. Close. Compact.

3. Add the text box to your form again.

If you don't actually need to edit the text box, another approach would be
to use a calculated control. Change the Name property of the text box so
it's not the same as the field name. Then add = to the control source, e.g.
change MyField to =[MyField]

 

[JamesJ]

Thanks, but I got it sorted out. Was just wondering why the Memo Field's
Text Format
property in the table defaults to Rich Text but the Text Format property
of the same field on the form defaults to Plain Text.
Just curious.

Thanks
James

Access can get confused if you alter the property in the table after
you've created the form.

If you can't get it sorted out, try these steps:

1. Make sure Name AutoCorrect is off:
http://allenbrowne.com/bug-03.html

2. Delete the text box from the form. Save. Close. Compact.

3. Add the text box to your form again.

If you don't actually need to edit the text box, another approach would be
to use a calculated control. Change the Name property of the text box so
it's not the same as the field name. Then add = to the control source,
e.g. change MyField to =[MyField]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I created a memo field for general notes and found that after placing
it on a form I was unable to have the text formatted in Rich Text even
though the field's Text Format property in the table was set to Rich
Text.
I found that at the form level this same property was set to Plain Text.
Why does the field at the table level default to Rich Text and the field
on on the form default to Plain Text????

 

[JamesJ]

In checking this again I'm in error. When I create a new memo field
in the table it actually defaults to Plain Text providing it is the only
Memo field in the table.

James

Access can get confused if you alter the property in the table after
you've created the form.

If you can't get it sorted out, try these steps:

1. Make sure Name AutoCorrect is off:
http://allenbrowne.com/bug-03.html

2. Delete the text box from the form. Save. Close. Compact.

3. Add the text box to your form again.

If you don't actually need to edit the text box, another approach would be
to use a calculated control. Change the Name property of the text box so
it's not the same as the field name. Then add = to the control source,
e.g. change MyField to =[MyField]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I created a memo field for general notes and found that after placing
it on a form I was unable to have the text formatted in Rich Text even
though the field's Text Format property in the table was set to Rich
Text.
I found that at the form level this same property was set to Plain Text.
Why does the field at the table level default to Rich Text and the field
on on the form default to Plain Text????