Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

After Update easy ? 1

Status
Not open for further replies.

Utracman

Programmer
Mar 12, 2001
20
US


A97
I want to change the forecolor on part of my after update event value.

Code for the afterUpdate event on a memo field

Me!txtRtsNotes = Me!txtRtsNotes & " " & Month(Now) & "/" & Day(Now)

I want the date stuff to be blue like 16711680

Thanks for the help

Dave To learn fron those who have mastered the art..... Saves many headaches!
 
Unless you have a non-standard control, vba/ms. access does not support multiple colors in control fields, There are some 'workarounds' and thrid party controls which can (mostly) be made to fool some of the casual users.

RichTextBoc has been mentioned as one which does permit different fonts/colorr within the control.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over
 
THanks, but I only want the date part to be a different color, So in the memo field Dates stand out more.

Anys work arounds out there?

Dave To learn fron those who have mastered the art..... Saves many headaches!
 
Change Font Color to blue
MyDateControl.ForeColor = 16711680

Change Background of control to blue
MyDateControl.BackColor = 16711680
Joe Miller
joe.miller@flotech.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top