Yes/No field-How to fix

[Guest]

Hi all,

I convert the application from Dbase to Microsoft Access. It has a field name field name Plist (Hazardous Materials) Data type is Yes/NO (Yes=-1, No=0).

In a form. When the cursor is in this field (Yes/No) if I click on it. It turns to -1 or 0 depends on if it is Yes or No.

What I want is I do not want this happend.
1. I want it always appears as Yes or No not -1 or 0
2. I want to have a listbox that has Yes/No only. So that I will not have to enter when this field need to be fill.

Are there any suggestion that would help. I thank you for your long supports.

Regards,
Le Tran

 

[tina]

in the form, change the control type from Textbox to Combo Box. to do this,
select the textbox control, then on the menu bar click Format, Change To...
and select ComboBox.
set the following properties for the combobox:
RowSourceType: Value List
RowSource: 0;False;-1;True
ColumnCount: 2
ColumnWidths: 0";1"
LimitToList: Yes

hth

Hi all,

I convert the application from Dbase to Microsoft Access. It has a field

name field name Plist (Hazardous Materials) Data type is Yes/NO (Yes=-1,
No=0).

In a form. When the cursor is in this field (Yes/No) if I click on it. It

turns to -1 or 0 depends on if it is Yes or No.

What I want is I do not want this happend.
1. I want it always appears as Yes or No not -1 or 0
2. I want to have a listbox that has Yes/No only. So that I will not

have to enter when this field need to be fill.

 

[Rick B]

Is your field a combo-box?
Is the format set to "Yes/No"?
Is your Row Source Type set to "Value List"?
In the Row Source, do you have "Yes;No"?

If you do all those things, I think you will get your desired results.

Rick B



Hi all,

I convert the application from Dbase to Microsoft Access. It has a field
name field name Plist (Hazardous Materials) Data type is Yes/NO (Yes=-1,
No=0).

In a form. When the cursor is in this field (Yes/No) if I click on it. It
turns to -1 or 0 depends on if it is Yes or No.

What I want is I do not want this happend.
1. I want it always appears as Yes or No not -1 or 0
2. I want to have a listbox that has Yes/No only. So that I will not have
to enter when this field need to be fill.

Are there any suggestion that would help. I thank you for your long
supports.

Regards,
Le Tran

 

[Guest]

Hi all,
Thank you very much. It works fine now.
Regards,
Le Tran