Comb box default value column heaing?

[Torilyn73]

I have a combo box set up off a query. I want the default value to be
the column heading so I don't have to put a label over it. So far I
haven't been able to figure this out. Can anyone tell me if this is
possible... and if so..how?

Thanks!

[Baz]

Ugh, you want an Access combo box to behave as though it were on a smelly
HTML form!

I guess you could leave the combo box unbound and use code in the form's
BeforeUpdate even to grab it's value (assuming it's not the default), if you
really must. But, if the combo is bound, there's no way to get a value to
display unless the value is in the RowSource. You might be able to contrive
something with a text box carefully positioned over the combo box with event
code switching the focus when necessary, but really, it's not worth the
effort.

"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...

I have a combo box set up off a query. I want the default value to be
the column heading so I don't have to put a label over it. So far I
haven't been able to figure this out. Can anyone tell me if this is
possible... and if so..how?

Thanks!

[Torilyn73]

It it's reallly complicated.. then forget it. Let me explain a little
what I'm doing here.

I have a database set up with about 200 common responses that I (and my
coworkers) use in replying to customers via email. It's technical
support for a computer company. I'm hoping this thing will help us work
smarter, not harder! Anyway.. my table has about 67 different
categories (headings), They are yes/no fields. Each common response is
assigned to at least one. I created a query for each catergory and now
need to create the main form to view these common responses. It needs
one large text box to display the common response and then a combo box
for each category that will show the list of what is assigned to that
category, when the record is selected... the text of the common
response is in the txt box. I have this set up already. My problem is I
don't have room for all these combo boxes and their labels. If I can
simplify the look with each combo box showing the column heading
(category name) as the default, then I can lose the labels off the
form. I was hoping there was just some trick to doing this.

What if I just create a multiple records each titled by a different
category and then assigned to their respective categories. That should
work, and I will end up with 67 records that are nothing but a name...
but thats ok. I'm going to try that and see what happens.

If anyone has other ideas... I am all ears.... er... eyes!! hehe
Baz wrote:

Ugh, you want an Access combo box to behave as though it were on a smelly
HTML form!

I guess you could leave the combo box unbound and use code in the form's
BeforeUpdate even to grab it's value (assuming it's not the default), if you
really must. But, if the combo is bound, there's no way to get a value to
display unless the value is in the RowSource. You might be able to contrive
something with a text box carefully positioned over the combo box with event
code switching the focus when necessary, but really, it's not worth the
effort.

"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...

I have a combo box set up off a query. I want the default value to be
the column heading so I don't have to put a label over it. So far I
haven't been able to figure this out. Can anyone tell me if this is
possible... and if so..how?

Thanks!

[Baz]

From that description it sounds to me as though your combo boxes may not be
bound, in which case just set the "Default Value" property to your desired
title.

It's rarely good user interface design to cram as much as possible onto a
form, which is what you have done if you don't even have room for labels.
Even if you do succeed in gettting all your controls on the one form, some
user is sure to undo your hard work by insisting on using a chunkier screen
resolution than you designed the form for.
"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...

It it's reallly complicated.. then forget it. Let me explain a little
what I'm doing here.

I have a database set up with about 200 common responses that I (and my
coworkers) use in replying to customers via email. It's technical
support for a computer company. I'm hoping this thing will help us work
smarter, not harder! Anyway.. my table has about 67 different
categories (headings), They are yes/no fields. Each common response is
assigned to at least one. I created a query for each catergory and now
need to create the main form to view these common responses. It needs
one large text box to display the common response and then a combo box
for each category that will show the list of what is assigned to that
category, when the record is selected... the text of the common
response is in the txt box. I have this set up already. My problem is I
don't have room for all these combo boxes and their labels. If I can
simplify the look with each combo box showing the column heading
(category name) as the default, then I can lose the labels off the
form. I was hoping there was just some trick to doing this.

What if I just create a multiple records each titled by a different
category and then assigned to their respective categories. That should
work, and I will end up with 67 records that are nothing but a name...
but thats ok. I'm going to try that and see what happens.

If anyone has other ideas... I am all ears.... er... eyes!! hehe
Baz wrote:

Ugh, you want an Access combo box to behave as though it were on a

smelly

HTML form!

I guess you could leave the combo box unbound and use code in the form's
BeforeUpdate even to grab it's value (assuming it's not the default), if

you

really must. But, if the combo is bound, there's no way to get a value

to

display unless the value is in the RowSource. You might be able to

contrive

something with a text box carefully positioned over the combo box with

event

code switching the focus when necessary, but really, it's not worth the
effort.

"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...

I have a combo box set up off a query. I want the default value to be
the column heading so I don't have to put a label over it. So far I
haven't been able to figure this out. Can anyone tell me if this is
possible... and if so..how?
>
Thanks!
>

[Torilyn73]

I agree about the user interface being too cluttered however, we only
have about 7 people who will use it. At the moment the solution we have
requires a lot of scrolling and clicking on different links to get to
the page you need and then when done you have to back track to the home
page.

I may end up chucking this idea and coming up with something else...
who knows.
Baz wrote:

From that description it sounds to me as though your combo boxes may not be
bound, in which case just set the "Default Value" property to your desired
title.

It's rarely good user interface design to cram as much as possible onto a
form, which is what you have done if you don't even have room for labels.
Even if you do succeed in gettting all your controls on the one form, some
user is sure to undo your hard work by insisting on using a chunkier screen
resolution than you designed the form for.
"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...

It it's reallly complicated.. then forget it. Let me explain a little
what I'm doing here.

I have a database set up with about 200 common responses that I (and my
coworkers) use in replying to customers via email. It's technical
support for a computer company. I'm hoping this thing will help us work
smarter, not harder! Anyway.. my table has about 67 different
categories (headings), They are yes/no fields. Each common response is
assigned to at least one. I created a query for each catergory and now
need to create the main form to view these common responses. It needs
one large text box to display the common response and then a combo box
for each category that will show the list of what is assigned to that
category, when the record is selected... the text of the common
response is in the txt box. I have this set up already. My problem is I
don't have room for all these combo boxes and their labels. If I can
simplify the look with each combo box showing the column heading
(category name) as the default, then I can lose the labels off the
form. I was hoping there was just some trick to doing this.

What if I just create a multiple records each titled by a different
category and then assigned to their respective categories. That should
work, and I will end up with 67 records that are nothing but a name...
but thats ok. I'm going to try that and see what happens.

If anyone has other ideas... I am all ears.... er... eyes!! hehe
Baz wrote:

Ugh, you want an Access combo box to behave as though it were on a

smelly

HTML form!
>
I guess you could leave the combo box unbound and use code in the form's
BeforeUpdate even to grab it's value (assuming it's not the default), if

you

really must. But, if the combo is bound, there's no way to get a value

to

display unless the value is in the RowSource. You might be able to

contrive

something with a text box carefully positioned over the combo box with

event

code switching the focus when necessary, but really, it's not worth the
effort.
>
"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...
I have a combo box set up off a query. I want the default value to be
the column heading so I don't have to put a label over it. So far I
haven't been able to figure this out. Can anyone tell me if this is
possible... and if so..how?

Thanks!