Yes/No field-How to fix

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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


Le Tran said:
Hi all,

I convert the application from Dbase to Microsoft Access. It has a field
Click to expand...
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
Click to expand...
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
Click to expand...
have to enter when this field need to be fill.
 
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
 
Back
Top