By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Insert or add a rich text in memo field (access 2003)

medim84
P: 4
How to format text in memo field for predefine text, using - default value - expression builder? For e.g. new row, bold text, font size…

Thanks
Aug 16 '07 #1
Share this Question
Share on Google+
4 Replies


medim84
P: 4
Please............................,

anyone?
Aug 17 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
Welcome to TheScripts!

The reason you haven't received any responses, I suspect, is that this is an area that is so complicated and time consuming that experienced Access developers have long ago decided that "nice" displays are simply not worth the effort!

The Access native Rich Textbox ActiveX Control is a diaster, from what I've heard over the years. Stephen Lebans, who has routines for a multitude of specialty things being used by thousands of developers, has a hack for this availible gratis at http://www.lebans.com/richtext.htm but, and this is unusual for him, it's been riddled with problems/bugs over the years, which speaks volumes of the complexity of the problem.

There are 3rd party add-ins, for $$$$, out there, but I have no experience with them, and they ususally are BIG$$$$$$. Access 2007 has RTF available as a standard feature, I understand, but haven't heard any reports back on that.

And finally, formatting, of any sort, of memo fields, leads to all sorts of problems when these fields are used in queries, ususally causing the fields to be truncated to 255 characters.

Linq ;0)>
Aug 17 '07 #3

medim84
P: 4
Welcome to TheScripts!

The reason you haven't received any responses, I suspect, is that this is an area that is so complicated and time consuming that experienced Access developers have long ago decided that "nice" displays are simply not worth the effort!

The Access native Rich Textbox ActiveX Control is a diaster, from what I've heard over the years. Stephen Lebans, who has routines for a multitude of specialty things being used by thousands of developers, has a hack for this availible gratis at http://www.lebans.com/richtext.htm but, and this is unusual for him, it's been riddled with problems/bugs over the years, which speaks volumes of the complexity of the problem.

There are 3rd party add-ins, for $$$$, out there, but I have no experience with them, and they ususally are BIG$$$$$$. Access 2007 has RTF available as a standard feature, I understand, but haven't heard any reports back on that.

And finally, formatting, of any sort, of memo fields, leads to all sorts of problems when these fields are used in queries, ususally causing the fields to be truncated to 255 characters.

Linq ;0)>
Thanks,
I realize how it’s complicate when I sow price of 3rd add-ins, they even more expensive then office 2007 which includes RTF
Aug 17 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
That's right! A pretty good rule of thumb is the costlier the add-ins the more difficult they've been to develop. Sometimes it's worth it; if you've got a budget to handle it or your development fees can bear it, or it's something you anticipate using repeatedly. My apps are primarily for non-techies, and they tend to be gun-shy when they see the standard Access data entry formats, so I spend a bit of time customizing my forms to look more VB6 interfaces, with command buttons whose purposes are self-evident, but you can go too far, I think, in trying to "beautify" forms. Too be honest, when I see posts form people who want to make their Access apps "cool" with flashing textboxes and multi-colored tab pages and such, I almost never bother to respond.Those kind of frills belong in video games and websites, not on databases.

Have a good weekend!

Linq ;0)>
Aug 17 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.