Default value and font colours?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

evilcowstare - 19 Mar 2007 18:48 GMT

Hi, this is probably something really simple.
I have a drop-down box that gets its selections from a table, all I want to
do is set it up so that it automatically comes up with one of the items like
a default value unless someone wants to change it,
I had a look at the default value option in properties but cant work out how
to direct it to an actual entry in a table?

Also if you have a combo box that shows selections is it possible to make
just one of the selections a different colour font from the others?

Thank You for all your help!

Jay

Reply to this Message

Ryan - 19 Mar 2007 20:59 GMT

All you have to do is type the value that you want to be the default value,
you dont need to look it up. If you want your default value to be water just
type "water". Make sure that if the table is related that water is one of
the values in the related table. I don't know of any way to change the color
of the font on any drop down values, let alone just one. Hope that helps.

> Hi, this is probably something really simple.
> I have a drop-down box that gets its selections from a table, all I want to
[quoted text clipped - 9 lines]
>
> Jay

Reply to this Message

evilcowstare - 19 Mar 2007 21:15 GMT

I tried that but it doesnt work, it just displays 0
The combo looks up info from the table below
In the table i have
ID
1 Not Invoiced
2 Invoiced
3 See Notes
4 Valuation

If I put Not Invoiced into default value it puts a 0 in the combo and when i
go back to properties it has changed it to.... Not "Invoiced"

There are 2 column counts and it is bound to column 2, with the 1st column
(id) being invisible

Any Ideas?

>All you have to do is type the value that you want to be the default value,
>you dont need to look it up. If you want your default value to be water just
[quoted text clipped - 7 lines]
>>
>> Jay

Reply to this Message

Damon Heron - 19 Mar 2007 21:38 GMT

Bound column is normally the ID, which is 1. if you put the default
property = to the ID number, then the name will show up in the column.

Damon

>I tried that but it doesnt work, it just displays 0
> The combo looks up info from the table below
[quoted text clipped - 29 lines]
>>>
>>> Jay

Reply to this Message

Ryan - 19 Mar 2007 21:42 GMT

There are two ways to fix this problem. The first would be to remove the ID
field and just leave the named fields and make your default value Not
Invoiced. Your other option is to go to the table you want your values
stored in, then go to the field that you want your combo box based on, click
the lookup tab and set it up like this,

Display Control: Combo Box
Row Source Type: Table/Query
Row Source: (Your Table/Query)
Bound Colum: 1 (assuming your ID field is your Primary Key)
Column Count: 2
Column Heads: No
Column Widths: 0,1
List Rows: 8
List Width: Auto
Limit To List: Yes

Then go to the general tab and make the default value 1, which is your ID
for Not Invoiced. Once you create a form base on this table your Not
Invoiced will be the value already entered and if you wish to change it you
will have a drop down of your other choices. Good luck.

> I tried that but it doesnt work, it just displays 0
> The combo looks up info from the table below
[quoted text clipped - 24 lines]
> >>
> >> Jay

Reply to this Message

evilcowstare - 20 Mar 2007 01:02 GMT

Hi, just want to thank both of you for your help, I'll have a play about and
I think based on what is written I'll be able to work something out!

Thanks Again!!!!
All the best
Jay

>There are two ways to fix this problem. The first would be to remove the ID
>field and just leave the named fields and make your default value Not
[quoted text clipped - 23 lines]
>> >>
>> >> Jay

Reply to this Message

evilcowstare - 20 Mar 2007 01:07 GMT

Hi Just thought you may want to know I managed to fix the problem, I just had
to put speech marks around whatever I wanted to show in Default Value, so
"Not Invoiced" , Something to remember for the future!

Thanks again for your help!!

>Hi, just want to thank both of you for your help, I'll have a play about and
>I think based on what is written I'll be able to work something out!
[quoted text clipped - 8 lines]
>>> >>
>>> >> Jay

Reply to this Message