Formatting Fonts

[DS]

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

[Rick Brandt]

"DS" <bo******@optonline.net> wrote in message
news:C%***************@fe08.lga...

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

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

[Bas Cost Budde]

DS wrote:

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

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

[DS]

Rick Brandt wrote:

"DS" <bo******@optonline.net> wrote in message
news:C%***************@fe08.lga...

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

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

Not to be a pain, but where is this placed? And how is this used in a
Query? Thanks for your help.
DS

[Rick Brandt]

"DS" <bo******@optonline.net> wrote in message
news:1_*****************@fe08.lga...

Not to be a pain, but where is this placed? And how is this used in a
Query? Thanks for your help.
DS

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

[DS]

Rick Brandt wrote:

"DS" <bo******@optonline.net> wrote in message
news:1_*****************@fe08.lga...

Not to be a pain, but where is this placed? And how is this used in a
Query? Thanks for your help.
DS

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])

Thanks
DS

[Tony D'Ambra]

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

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

"DS" <bo******@optonline.net> wrote in message
news:C%***************@fe08.lga...

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