bound column manual value if db value = 0 show yes else show no

M

maXim

Hi,
i have bool field in my db. i m using bound column to show this value. what
i want is if the field value is 0 then bound textbox must show no else it
must show yes. is that possible through bound columns
 
M

maXim

Dat was perfect...
now i need more help.
one of my column is a char column which contains "G" or "P". G means
government and P means private. How can i set its format.
Thank you very much.
 
A

Allen Browne

What do you want to see here?

Do you want the full words instead of the 3 letters?
If so, open your form in design view, right-click the text box, and choose:
Change To | Combo
Set these properties for the combo:
Row Source Type Value List
Row Source "G";"Government";"P";"Private"
Column Count 2
Column Widths 0
 
M

maXim

it shows blank combo box

Allen Browne said:
What do you want to see here?

Do you want the full words instead of the 3 letters?
If so, open your form in design view, right-click the text box, and choose:
Change To | Combo
Set these properties for the combo:
Row Source Type Value List
Row Source "G";"Government";"P";"Private"
Column Count 2
Column Widths 0
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
How to get the value of non-bound combo box column? 5
Lookup current record with ComboBox, any changes create new record 3
combo box - bound column 2
Data doesn't show up in bound fields 4
edit a bound textbox control on a form 4
Autonumber field in Excel that behaves the same as Access 0
Changing column bound, width, and column count 1

Top