conditional formatting

  • Thread starter Thread starter Jason
  • Start date Start date
J

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
 
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
 
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.
 
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...
 
Back
Top