dbTalk Databases Forums  

Formatting Fonts

comp.databases.ms-access comp.databases.ms-access


Discuss Formatting Fonts in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DS
 
Posts: n/a

Default Formatting Fonts - 12-17-2004 , 10:41 AM






How do you Format a Font in a Combo Box? I went to Properties and put a
Quote:
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


Reply With Quote
  #2  
Old   
Bas Cost Budde
 
Posts: n/a

Default Re: Formatting Fonts - 12-17-2004 , 11:31 AM






DS wrote:
Quote:
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


Reply With Quote
  #3  
Old   
Rick Brandt
 
Posts: n/a

Default Re: Formatting Fonts - 12-17-2004 , 12:01 PM



"DS" <bootybox (AT) optonline (DOT) net> wrote

Quote:
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




Reply With Quote
  #4  
Old   
DS
 
Posts: n/a

Default Re: Formatting Fonts - 12-17-2004 , 12:56 PM



Rick Brandt wrote:

Quote:
"DS" <bootybox (AT) optonline (DOT) net> wrote in message
news:C%Dwd.1178$Ve.934 (AT) fe08 (DOT) 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


Reply With Quote
  #5  
Old   
Rick Brandt
 
Posts: n/a

Default Re: Formatting Fonts - 12-17-2004 , 01:34 PM



"DS" <bootybox (AT) optonline (DOT) net> wrote

Quote:
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




Reply With Quote
  #6  
Old   
DS
 
Posts: n/a

Default Re: Formatting Fonts - 12-17-2004 , 01:55 PM



Rick Brandt wrote:
Quote:
"DS" <bootybox (AT) optonline (DOT) net> wrote in message
news:1_Fwd.1212$vF1.1109 (AT) fe08 (DOT) 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


Reply With Quote
  #7  
Old   
Tony D'Ambra
 
Posts: n/a

Default Re: Formatting Fonts - 12-17-2004 , 06:26 PM



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


--

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

"DS" <bootybox (AT) optonline (DOT) net> wrote

Quote:
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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.