Changing a checkbox

[Lou_Reed]

This question may have been answered before and if so then I apologize. I am entering via a form a lot of personnel data.

In one part of the record it asks something, in this case whether the person of interest is active true or false. Obviously, this is a Boolean expression.

Now on the form is has a checkbox that was put either by me or someone else, that while categorically appropriate is clearly the wrong
format. It clearly should be true or false, yes or no, but not check box or no checkbox.



How do I switch it over it could be a combo box or it could just be type Yes/No or True/False. I must change this in the table and the form.

Any help appreciated. Thanks in advance.


Respectfully,


Lou_Reed

[ranman256]

its all the same value.
yes/true/-1
no/false/0

check box values all mean the same...its just how you want to see them (format)
you can choose to view them as yes/no
or true/false

you don't have to change anything.

like dates. its all the same value but you can view it in any format.

[Lou_Reed]

Okay, thanks I will give it a try. Also, I noticed on the tables associated with the form that in the Boolean
record it is shown as a checkbox. Is this standard practice for tables? To show Booleans a checkboxes?

I guess it must be; then all one needs to do is modify the report checkbox?

Any help appreciated. thanks in advance.

Respectfully,


Lou_Reed

[John_G]

You normally shouldn't be looking at tables directly anyway (that's what forms are for), but during development, we all do it. The checkbox is the default display; you can change how a Yes/No is displayed through table design view. Select the field you want to modify, then click the "Lookup" tab in the properties (I have no idea why MS put that into Lookup). From the dropdown for Display Control, select "Text Box".

Then click the "General" tab, and from the "Format" dropdown, select the Values you want to see.

This does not affect the data stored in the table field (it's numeric). Forms and reports can be set up to show the data on whatever format you choose; it is independent of the table design setting.

[Lou_Reed]

Say we have a table and its associated table. The table has a checkbox; yes if the box is checked and no if it is not checked. Now can we just modify the
form so when we input we can use a combo box (with choices yes and no) and then it shows up on the tables as checked or unchecked box?

I think that this would be easier that having a table with text and capable of entering yes or no.

is this possible or must we the table with something else. ?

Any help appreciated. Thanks in advance.

Respectfully,


Lou_Reed

[Lou_Reed]

I do not think that last question made a lot of sense. I am inputting data into a Personnel form and it is being recorded
in a Personnel table. Thus the Personnel form needs an combo (with the choices of yes or no) box on the form.

Then of course this must be reflected back in the Personnel table.

Should the Personnel table also be reflected yes or no and not a checked or unchecked box?

Any help appreciated. Thanks in advance.

Respectfully,


Lou_Reed

[John_G]

Yes, for that type of data, you should always use a Yes/No data type. It is stored internally in the table as numeric data ( 0 or -1), but how you display it is up to you (Checkbox, Yes/No, True/False), and will be dictated to some extent by the data. A selected option might be displayed as a checkbox, whereas the answer to a question (e.g. "Escort Required?") might be displayed as Yes or No. There is no requirement that the same data be displayed in the same format in different places.

Just as an aside, you should not be worrying about how such data is displayed in a table as a datasheet - in production mode (as opposed to development), you should always use forms for displaying or entering data.

[Lou_Reed]

Okay, right now on a Personnel form, I have a box that says whether the employee is active or not.

On this form I have the choice between typing True or False. Actually, I would rather use Yes (for True) and No (for False).

It just seems to make more sense.

How can I change the Personnel form on the Active box to show Yes or No instead of True or False.

This seems to be determined by the data and the software. Simply put, I want Yes or No; not True or False.

Any help appreciated.

Thanks in advance.

Respectfully,


Lou_Reed

[Lou_Reed]

Never mind. I know how to do that what I asked in the last question. It is the format section you are given choices.

Now I would like to ask a different question.

I am inputting the data in the form. I must now type in Yes or No.

But if someone else is inputting data into the form and the box gives no hints, then how does one know to input only Yes or No?
The answer change into a combo where the only choices are Yes and No? So how do I do that?

Any help appreciated. Thanks in advance.

I apologize for the serpentine way I got this sorted out.


Respectfully,


Lou_Reed

[CJ_London]

make the label say 'Active?' or 'Active Y/N'

use the controltip text

use validation rule

to change from text box to combobox, right click to view properties then select change to> combobox

Don't forget to set the combobox properties to what you require - you will need value list and rowsource of Yes;No or change it round to No;Yes - and will no doubt need a default

[Lou_Reed]

Okay, but now I have a combo box, but no values when the menu opens. I would like to just
type them in. No need for anything else such as the Wizard, etc.

So how do I add values to thee combo box by typing them?

Any help appreciated. Thanks in advance.

Respectfully,


Lou_Reed

[CJ_London]

see my last paragraph

[Lou_Reed]

ImportantFile.zip

Okay, the file is attached above. I am having trouble on the Parking. The box under occuopied

is a combo box. The choices should be yes ot no.


Nothing else.


I put that in record source as instructed and it does not like it*. I believe this is the correct
format. I do not see how it could be wrong, but it is.

Again it is on the parking Form for occupied. the combo should show yes or no.


Why is it not showing that.

Respectfully,


Lou_Reed

*the record source "Yes";"No" as specified does not exist or the form does not link to it. Is the error message.

[CJ_London]

I refer you again to my last paragraph

Don't forget to set the combobox properties to what you require - you will need value list and rowsource of Yes;No or change it round to No;Yes - and will no doubt need a default

I'll give you a clue - value list is a row source type