Hiding Fields on Continous Form

D

DS

I have two fields on my continous form. Depending on a condition I need
one or the other field to show. The problem is that when one or the
other shows it shows for every record not just the current record. Any
way around this?
Thanks
DS
 
D

DS

Lynn said:
That's the nature of continuous forms. You might take a look at conditional
formatting.
I tried that but I have fields that are disabled and locked.
Conditional formatting lets the user go into the field.
DS
 
D

DS

Stephen said:
Here is a previous post of mine on this issue:

Newsgroups: microsoft.public.access.formscoding
From: "Stephen Lebans" <[email protected]> - Find messages by this
author
Date: Mon, 2 Jun 2003 21:26:33 -0300
Local: Mon,Jun 2 2003 8:26 pm
Subject: Re: Color Current Record
Reply to Author | Forward | Print | Individual Message | Show original |
Report Abuse

Marsh I generally reccommend that the CF for this background TextBox
control be applied programmatically via the FormatConditions object in
the Form's Load event. There is a bug when you setup CF via its UI that
will Enable the TextBox control, even if you have set it to Disabled in
the CF UI.
Sample code is here:
http://www.lebans.com/conditio­nalformatting.htm



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
So thats what they call a "BUG"! I knew something was up! So is there
a workaround...I tried the link but it's broken.
Thanks
DS
 
Top