New line in memo box
in [General]
|
Prev: Functions to = a total field
Next: VIGILANTES DE SEGURIDAD DENUNCIAN EL INTRUSISMO DE LOS AUXILIARES DE CONTROL-AUXILIARES DE SERVICIO
From: John W. Vinson on 7 May 2010 21:07 On Fri, 7 May 2010 15:36:01 -0700, jwebster1979 <jwebster1979(a)discussions.microsoft.com> wrote: >Thankyou that works great one more question. I also want a check box that >will turn the text red for a specific note and hold that color to draw >attention to to it. Or if it is not checked the text will be black and hold >that color. Let me know if you know how to do that. Either way I appreciate >your help!! If you have all the data in one single big memo field, this will be difficult. At the best you'll need to make it a Rich Text textbox (which will make it even *more* difficult to search), with either manual selection of the text you want to see in red or some REALLY complex VBA code. It would be much easier if each note were in a separate record - then you could use conditional formatting. -- John W. Vinson [MVP] |