![]() | |
#1
| |||
| |||
|
|
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 |
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
"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 |
#5
| |||
| |||
|
|
Not to be a pain, but where is this placed? And how is this used in a Query? Thanks for your help. DS |
#6
| |||
| |||
|
|
"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 |
#7
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |