Conditional Formating

[Tom]

Is there any way to use conditional formating to change a control for a
field in a continuous form to a textbox, option group or combobox depending
on the value of another field on the form? On a continuous form, I need some
records to have a textbox, some to have an option group and some to have a
combobox in the same field.

Thanks,

Tom

[Stephen Lebans]

Re: Conditional Formating

That sure sounds like a non standard UI but it's your App.
You cannot directly use CF to achieve your UI.

The only approach I can think of is to:
1) Include all of the controls on each row.
2) Use CF to Enable/Disable each control as required.

--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Tom" <NotMy@email.co m> wrote in message
news:lV0ie.5604 $w21.5510@newsr ead3.news.atl.e arthlink.net...[color=blue]
> Is there any way to use conditional formating to change a control for[/color]
a[color=blue]
> field in a continuous form to a textbox, option group or combobox[/color]
depending[color=blue]
> on the value of another field on the form? On a continuous form, I[/color]
need some[color=blue]
> records to have a textbox, some to have an option group and some to[/color]
have a[color=blue]
> combobox in the same field.
>
> Thanks,
>
> Tom
>
>[/color]

[Tom]

Re: Conditional Formating

Stephen,

Thanks for your response!

It's for recording answers to a questionaire. Some questions require a
textbox, some an option group for Yes/No and some a combobox to select from
a list. Any ideas?

Tom


"Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot com@linvalid.co m>
wrote in message news:3T2ie.1392 0$Ph4.500504@ur sa-nb00s0.nbnet.nb .ca...[color=blue]
> That sure sounds like a non standard UI but it's your App.
> You cannot directly use CF to achieve your UI.
>
> The only approach I can think of is to:
> 1) Include all of the controls on each row.
> 2) Use CF to Enable/Disable each control as required.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Tom" <NotMy@email.co m> wrote in message
> news:lV0ie.5604 $w21.5510@newsr ead3.news.atl.e arthlink.net...[color=green]
> > Is there any way to use conditional formating to change a control for[/color]
> a[color=green]
> > field in a continuous form to a textbox, option group or combobox[/color]
> depending[color=green]
> > on the value of another field on the form? On a continuous form, I[/color]
> need some[color=green]
> > records to have a textbox, some to have an option group and some to[/color]
> have a[color=green]
> > combobox in the same field.
> >
> > Thanks,
> >
> > Tom
> >
> >[/color]
>[/color]

[Stephen Lebans]

Re: Conditional Formating

For a form in Continuous view then only what I stated in my original
reply.

If you have the flexability to modify the questionaire's structure, then
a TAB control with 3 pages each containing a form set to Continuous
view, is a possible solution. Each page would contain the grouping of
questions requiring one of the specific types of controls you metnioned.

--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Tom" <NotMy@email.co m> wrote in message
news:lq3ie.2633 $M36.1460@newsr ead1.news.atl.e arthlink.net...[color=blue]
> Stephen,
>
> Thanks for your response!
>
> It's for recording answers to a questionaire. Some questions require a
> textbox, some an option group for Yes/No and some a combobox to select[/color]
from[color=blue]
> a list. Any ideas?
>
> Tom
>
>
> "Stephen Lebans"[/color]
<ForEmailGotoMy .WebSite.-WWWdotlebansdot com@linvalid.co m>[color=blue]
> wrote in message[/color]
news:3T2ie.1392 0$Ph4.500504@ur sa-nb00s0.nbnet.nb .ca...[color=blue][color=green]
> > That sure sounds like a non standard UI but it's your App.
> > You cannot directly use CF to achieve your UI.
> >
> > The only approach I can think of is to:
> > 1) Include all of the controls on each row.
> > 2) Use CF to Enable/Disable each control as required.
> >
> > --
> >
> > HTH
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
> >
> >
> > "Tom" <NotMy@email.co m> wrote in message
> > news:lV0ie.5604 $w21.5510@newsr ead3.news.atl.e arthlink.net...[color=darkred]
> > > Is there any way to use conditional formating to change a control[/color][/color][/color]
for[color=blue][color=green]
> > a[color=darkred]
> > > field in a continuous form to a textbox, option group or combobox[/color]
> > depending[color=darkred]
> > > on the value of another field on the form? On a continuous form, I[/color]
> > need some[color=darkred]
> > > records to have a textbox, some to have an option group and some[/color][/color][/color]
to[color=blue][color=green]
> > have a[color=darkred]
> > > combobox in the same field.
> > >
> > > Thanks,
> > >
> > > Tom
> > >
> > >[/color]
> >[/color]
>
>[/color]