Formatting Fonts

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • DS
    #1

    Formatting Fonts

    How do you Format a Font in a Combo Box? I went to Properties and put a[color=blue]
    > sign to make the letters all caps and it doesn't work, Column 1 is[/color]
    bound, hidden and a number, Column 2 is visible and text. I just want
    to make them all caps for this report only.
    Thnaks
    DS
    Tags: None
    • Rick Brandt
      #2
      Re: Formatting Fonts

      "DS" <bootybox@opton line.net> wrote in message
      news:C%Dwd.1178 $Ve.934@fe08.lg a...[color=blue]
      > How do you Format a Font in a Combo Box? I went to Properties and put a[color=green]
      > > sign to make the letters all caps and it doesn't work, Column 1 is[/color]
      > bound, hidden and a number, Column 2 is visible and text. I just want
      > to make them all caps for this report only.
      > Thnaks
      > DS[/color]

      Modify the query used for the RowSource of the ComboBox and force it to all
      caps there. Use the UCase() function.


      --
      I don't check the Email account attached
      to this message. Send instead to...
      RBrandt at Hunter dot com


        Comment

        • Bas Cost Budde
          #3
          Re: Formatting Fonts

          DS wrote:[color=blue]
          > How do you Format a Font in a Combo Box? I went to Properties and put a[color=green]
          > > sign to make the letters all caps and it doesn't work, Column 1 is[/color]
          > bound, hidden and a number, Column 2 is visible and text. I just want
          > to make them all caps for this report only.
          > Thnaks[/color]

          I'd handle this in the rowsource. Such as select column1, ucase(column2)
          from thattable

          --
          Bas Cost Budde, Holland
          http://www.heuveltop.nl/BasCB/msac_index.html

          I prefer human mail above automated so in my address
          replace the queue with a tea

            Comment

            • DS
              #4
              Re: Formatting Fonts

              Rick Brandt wrote:
              [color=blue]
              > "DS" <bootybox@opton line.net> wrote in message
              > news:C%Dwd.1178 $Ve.934@fe08.lg a...
              >[color=green]
              >>How do you Format a Font in a Combo Box? I went to Properties and put a[color=darkred]
              >> > sign to make the letters all caps and it doesn't work, Column 1 is[/color]
              >>bound, hidden and a number, Column 2 is visible and text. I just want
              >>to make them all caps for this report only.
              >>Thnaks
              >>DS[/color]
              >
              >
              > Modify the query used for the RowSource of the ComboBox and force it to all
              > caps there. Use the UCase() function.
              >
              >[/color]
              Not to be a pain, but where is this placed? And how is this used in a
              Query? Thanks for your help.
              DS

                Comment

                • Rick Brandt
                  #5
                  Re: Formatting Fonts

                  "DS" <bootybox@opton line.net> wrote in message
                  news:1_Fwd.1212 $vF1.1109@fe08. lga...[color=blue]
                  > Not to be a pain, but where is this placed? And how is this used in a
                  > Query? Thanks for your help.
                  > DS[/color]

                  In design view look at the RowSource property of your ComboBox. It will
                  either be the name of a table, the name of a query, or a SQL statement. In
                  either case, press the build [...] button to the right and that will take
                  you to the query design window.

                  Where you currently have the name of the field you want to appear in all
                  caps replace the name of the field with the expression...

                  UCase([FieldName])


                  --
                  I don't check the Email account attached
                  to this message. Send instead to...
                  RBrandt at Hunter dot com


                    Comment

                    • DS
                      #6
                      Re: Formatting Fonts

                      Rick Brandt wrote:[color=blue]
                      > "DS" <bootybox@opton line.net> wrote in message
                      > news:1_Fwd.1212 $vF1.1109@fe08. lga...
                      >[color=green]
                      >>Not to be a pain, but where is this placed? And how is this used in a
                      >>Query? Thanks for your help.
                      >>DS[/color]
                      >
                      >
                      > In design view look at the RowSource property of your ComboBox. It will
                      > either be the name of a table, the name of a query, or a SQL statement. In
                      > either case, press the build [...] button to the right and that will take
                      > you to the query design window.
                      >
                      > Where you currently have the name of the field you want to appear in all
                      > caps replace the name of the field with the expression...
                      >
                      > UCase([FieldName])
                      >
                      >[/color]
                      Thanks
                      DS

                        Comment

                        • Tony D'Ambra
                          #7
                          Re: Formatting Fonts

                          You place the > in the Format property....


                          --

                          Tony D'Ambra
                          Web Site: aadconsulting.c om
                          Web Blog: accessextra.net

                          "DS" <bootybox@opton line.net> wrote in message
                          news:C%Dwd.1178 $Ve.934@fe08.lg a...[color=blue]
                          > How do you Format a Font in a Combo Box? I went to Properties and put a >
                          > sign to make the letters all caps and it doesn't work, Column 1 is bound,
                          > hidden and a number, Column 2 is visible and text. I just want to make
                          > them all caps for this report only.
                          > Thnaks
                          > DS[/color]


                            Comment

                            Previous template Next
                            Working...