SetValue to an item

kevin19

Registered User.
Local time
Today, 04:39
Joined
Jan 28, 2013
Messages
81
Hi All!
I have setvalue to an item when the date is changed, an expression " You cannot change!" appears in another textbox. This is working fine. But i need the text in this expression to appear in RED!
How can I do it?
Help please!
Thanks!
 
Try this:

If Me.yourtextboxname = "You cannot change!" then
Me.yourtextboxname.forecolor = vbred
Else
Me.yourtextboxname.forecolor = vbblack
End If
 
Hi Ed!
Thanks for your prompt response!
I had actually created the setvalue in a macro. the item for the set value is [Forms]![frmEditTasks]![frmsubEditTasks].[Form]![Notes].
The date is actually in the main form. If someone changes the date, the expression will appear in the notes textbox in the subform.
Where do I put in your code? I am on the learning curve with Access!!
Thanks!
Or is there a way where I can put the text and the format argument to make it red in the expression itself??
Please advise!
 
Hi Ed!
Thanks for your help! After trying various options, I managed to accomplish the task by using the conditional item from the ribbon menu.
Thanks!
 

Users who are viewing this thread

Back
Top Bottom