Hi all,
First of all let me clarify that i'm a total noob with both Access and VBA but was recently tasked with some work regarding Access. I consider myself a little bit tech savy but i'm still experimenting.
I have a report that use a combination of different fields, text box and the likes. the main part of my report is a RTF field where users enter long (and short) paragraphs, and tend to copy and paste a lot.
When people copy/paste their content in the RTF field they don't really bother with the font, size and colour.
I'm trying to come up with a solution to remove the "custom formatting" (specifically the font face and font size) to keep a somewhat consistent look throughout the report.
I need to be able to keep the bold, underline, italicize etc.
I have read online that RTF fields are actually more like HTML tags but can't figure out how to remove them, especially when font face and font size are used on the same paragraph.
I can somewhat live without having the same sizing being applied throughout but really need help getting rid of other font face.
I already have a macro firing up when the report is opened to sort some information.
Thanks for helping me out.
First of all let me clarify that i'm a total noob with both Access and VBA but was recently tasked with some work regarding Access. I consider myself a little bit tech savy but i'm still experimenting.
I have a report that use a combination of different fields, text box and the likes. the main part of my report is a RTF field where users enter long (and short) paragraphs, and tend to copy and paste a lot.
When people copy/paste their content in the RTF field they don't really bother with the font, size and colour.
I'm trying to come up with a solution to remove the "custom formatting" (specifically the font face and font size) to keep a somewhat consistent look throughout the report.
I need to be able to keep the bold, underline, italicize etc.
I have read online that RTF fields are actually more like HTML tags but can't figure out how to remove them, especially when font face and font size are used on the same paragraph.
I can somewhat live without having the same sizing being applied throughout but really need help getting rid of other font face.
I already have a macro firing up when the report is opened to sort some information.
Thanks for helping me out.