Memo field question

  • Thread starter Thread starter JudyB
  • Start date Start date
J

JudyB

I have a database that stores information about customer complaints. One of
the fields in the main table is a memo field to describe the complaint in
detail. Is there anyway to change the characteristics of the memo field so
that when filling out this field on a form, bullets or pressing the "enter"
key can be allowed to assist in emphasizing certain lines of text?

jubu
 
No, but you might consider whether the emphasised text is special enough to
be stored in a separate table, linked to your main table. Then you can do
searches and sorts on it, which you cant do if its buried in a memo field.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
JudyB said:
I have a database that stores information about customer complaints. One of
the fields in the main table is a memo field to describe the complaint in
detail. Is there anyway to change the characteristics of the memo field so
that when filling out this field on a form, bullets or pressing the "enter"
key can be allowed to assist in emphasizing certain lines of text?
Click to expand...

No easy way. Standard Access controls do not support anything like that so you
would have to use a Rich Text ActiveX control to do it.
 
I have a database that stores information about customer complaints. One of
the fields in the main table is a memo field to describe the complaint in
detail. Is there anyway to change the characteristics of the memo field so
that when filling out this field on a form, bullets or pressing the "enter"
key can be allowed to assist in emphasizing certain lines of text?
Click to expand...

You can get a little bit of the way toward this goal by changing the
Enter Key Behavior property of the textbox in which you display the
field on a Form (not in the table datasheet, which you shouldn't be
using in any case!) to "New Line in Field". This will let you

insert blank lines

and newline characters
in the middle of text, just as I have done in this message.

To get bullets, bold, italics or the like you must purchase or
otherwise obtain a "Rich Text Format" control and insert it on your
form; you may need to use Word or WordPad or some other RTF editor to
edit the data. The text in the actual memo field will then become
packed full of formatting commands and very hard to read except using
the RTF control.
 
Thanks!! That worked great!! - jb
John Vinson said:
You can get a little bit of the way toward this goal by changing the
Enter Key Behavior property of the textbox in which you display the
field on a Form (not in the table datasheet, which you shouldn't be
using in any case!) to "New Line in Field". This will let you

insert blank lines

and newline characters
in the middle of text, just as I have done in this message.

To get bullets, bold, italics or the like you must purchase or
otherwise obtain a "Rich Text Format" control and insert it on your
form; you may need to use Word or WordPad or some other RTF editor to
edit the data. The text in the actual memo field will then become
packed full of formatting commands and very hard to read except using
the RTF control.
Click to expand...
 
Back
Top