formatting one control but conditioning another

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • alf

    #1

    formatting one control but conditioning another

    Hi:
    I'm trying to show a text control in different format but using as
    condition another control. The idea is:
    Text1 shows field1 in normal text if field2=1
    and
    Text1 shows field1 in bold text if field2=2
    thats what I'm trying to do...
    Important: I'm using a continuos form, not a single form(here is
    obvious the solution) so in the same repeated control I want to get
    the same field but in different format.

    any help ??
  • Fredg

    #2
    Re: formatting one control but conditioning another

    What version of Access?
    If your using Access 2000 or newer, click on the [Text1] control.
    Then click on Format + Conditional Formatting.
    In the Condition 1 drop-down box select
    Expression Is
    In the Text box along side the drop-down, write:
    [Field2] = 2
    Click on the Condition 1 Bold tool button.
    Save the dialog and run the form.

    --
    Fred

    Please reply only to this newsgroup.
    I do not reply to personal e-mail.


    "alf" <admin@cubaautr ement.com> wrote in message
    news:4eaa1fa2.0 311250826.6f395 949@posting.goo gle.com...[color=blue]
    > Hi:
    > I'm trying to show a text control in different format but using as
    > condition another control. The idea is:
    > Text1 shows field1 in normal text if field2=1
    > and
    > Text1 shows field1 in bold text if field2=2
    > thats what I'm trying to do...
    > Important: I'm using a continuos form, not a single form(here is
    > obvious the solution) so in the same repeated control I want to get
    > the same field but in different format.
    >
    > any help ??[/color]


    Comment

    Working...