conditional formatting

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
 
B

BAC

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
 
J

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.
 
B

BAC

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top