conditional formatting

[Jason]

Hi,

How can i conditional format a contineous form in code?

I've tried the following but no result. I probably did something wrong.

With Form_MySubForm
.DataEntry = False
.Detail.Visible = True
.UniqueTable = "MySqlTable"
With .MyTextbox
.FormatConditions.add acFieldValue, acEqual, "=0"
.BackColor = vbRed
End With
End With

 

[Guest]

I've modified forms "on the fly" before and you have to first close the form
in its current state (if it's open), re-open it in design view, make the
changes, save/close then reopen acview normal.

Sounds like a lot, but it happens fairly quickly


BAC

 

[Jason]

Hi BAC,

Could you provide me the sample code so i can compare it with my code. I'd
like to see what i did wrong.

 

[Guest]

I couldn't find where I had done this before, but I'm pretty sure it came from:

http://www.mvps.org/access/forms/frm0024.htm

Download and look at the file for your app...

As I said, seems to me I had to open in design mode, make changes,
save/close and reoped "acform"/"acnormal"

Any questions, feel free to return for follow-up...

 

[Stephen Lebans]

There is sample code on my site here:
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.