Radio Button

[Martin Racette]

Hi,

I'm creating a database for a video store, and part of it si to list the actors
in the each movie, so far everything is working perfectly, but in the form that
I use to add new actor(s), it was suggested to me that I should use radio
buttons instead of a text field, to input the gender (there is only 2 gender
after all), but when I try to create it, the button insist on 1 and 2, but the
database will only accept M or F

How can I program the the buttons tu use the letters instead to 1 and 2,
changing the whole database to use 1 and 2 would be a very long and painful
process, as there are actually more than 1000 actors already in it

--
Thank you in Advance

Merci a l'Avance

Martin

 

[Douglas J. Steele]

You cannot use letters instead of numbers for radio buttons.

Changing your existing data should not be much effort at all: add a new
Gender field that's numeric and write an Update query to change all the Ms
to 1s and Fs to 2s.

Add a table that has 2 rows: one indicating that 1 is M and another
indicating that 2 is F. Link that table to your existing table, and you'll
be able to display M and F instead of 1 and 2 in your forms and reports.

 

[Martin Racette]

But I still have to change over 1000 entries by hand, since I don't use queries
and the table is set to use M or F only and that can not be change once the
database is in use (or so I have been told)

I don't get it the other table thing that you use, why do you use it for

BTW. why is there a point where when you create a box with radio button, that
you can specify the value, if you can not change the value to something that can
be use in the database.

--
Thank you in Advance

Merci a l'Avance

Martin

 

[Douglas J. Steele]

When you're specifying values to use with your radio buttons, you're
specifying the labels for them.

How is it possible that you've got a database and you "don't use queries"?
That's the basis of how everything works in Access!

 

[Martin Racette]

I don, t need queries, I just use filters instead, and they are a lot more
flexible

--
Thank you in Advance

Merci a l'Avance

Martin