Formatting without Conditional Formatting (Access 97)

[CSHANKY]

I requested a solution to this problem some weeks ago. The replies did not quite address what I wanted. Would someone take a fresh look and provide sample code?

I have a Access 97 database with Table1 with fields Complete1, Text1, Text2, Text3, which appear on a CONTNUOUS Form1.

How do I make ALL the fields Text1, Text2, Text3 boxes appear SHADED light-blue for the records when Complete1 is "YES" ? The fields should retun to their normal non-shaded format when the Complete1 field is NO.

In summary, the Complete1 field is like a toggle switch for the Text1, Text2, Text3 fields: "YES" - Text Boxes shade blue , "No" - - Text Boxes un-shaded, normal

Please note conditional formatting is be ruled out.

Thanks a LOT !

 

[danvlas]

NOT possible in continuous forms.

That's simply it...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[nberryman]

I'm dragging this from the back of my mind but it goes something like.

Copy the field and make the control source an IIF statement that check the value of the yes no field and displays the field or not depending on the condition.

Make this fields background transparant and move it over the top of the original field. If the condition is true then the field shows, if not the it's transparent and empty so the field under it shows. I know it works as I have done it before on a continuous form.

Let me know if there's a problem and I will try to dig out the old DB.

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[danvlas]

Neil, I'll prepare a star for the moment when you have that old db available. I'm really curious how to make ONE row in a continuous form different from the others without conditional formatting...

Cheers,




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[RoyVidar]

Hi!

Danvlas is correct, but I found this link somewhere, where there's some examples of achieving some effects thru a little tweaking. I've only downloaded the thingies myself to see that it actually performs something (I'm rather happy with a2000+ versions, so I don't see myself using it, but it does demonstrate "conditional formatting" in a97). Perhap you might give it a try and see if you can make it fit your challenge?

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

HTH Roy-Vidar

 

[roytheboy]

I use IIf statements all the time as we still have some databses on 97 for certain reasons... rest is on 2000.

IIF is the method you need to use and hidden fields with show /hide or populate.

Roy