471,066 Members | 1,376 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

Form Conditional Formatting

First off I have searched on this forum and others for about 1.5 hours and can't find relevant information.

I have a form that is in viewsheet or datasheet mode so when you click it it looks like a spreadsheet.

this is the code that i want to expand but I have to get it working first.

With Me.Description
If .Value = "Print Not Available" Then
.ForeColor = vbRed
End If
End With

description is a column in the frmDatabase.

However it doesn't change the datasheet. It reads the value correctly and even runs through the forecolor and changes it to vbred however it doesn't push those changes to the spreadsheet. So it looks like it runs through the loop correctly but doesn't apply the conditional formatting to the spreadsheet.
Jan 13 '08 #1
2 1517
update I changed it to

strDestination = me.destination

select case
case "Print Not Available"
me.destination.backcolor = vbblack
end select

that doesn't work HOWEVER this does

select case
case "Print Not Available"
me.destination = "Works"
end select

so it will allow me to change value but not backcolor or anything like that
Jan 13 '08 #2
missinglinq
3,532 Expert 2GB
Where do you have this code placed? It would help to actually see the entire sub it resides in.

Linq ;0)>
Jan 14 '08 #3

Post your reply

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

Similar topics

3 posts views Thread by Prakash Wadhwani | last post: by
4 posts views Thread by Randy Harris | last post: by
4 posts views Thread by cefrancke | last post: by
2 posts views Thread by jerry.ranch | last post: by
2 posts views Thread by Filips Benoit | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.