By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,464 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Formatting Fonts

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"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
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
"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
Nov 13 '05 #5

P: n/a
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
Nov 13 '05 #6

P: n/a
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

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.