Hi
Re : MS Access 2013 Form - Radio Buttons - Gender Entry - M or F
I am not an expert with MS Access and hence posting a very basic question.
We are connected with education field and this doubt is worrying our students.
Unfortunately the school ICT teachers have neither attended to the doubt nor have solved it.
The students are asked to create Radio button in MS Access form for field 'Gender' where the data input is either 'M' or 'F'.
When we create radio buttons, it is allowing to enter values in the database table in numerical form only i.e. 1 for Male and 2 for Female.
Have the following doubts:-
(1) Can we enter thru the radio buttons - alphabets 'M' or 'F' in the database table instead of '1' or '2'? Does any such functionality exist in MS Access?
(2) If not and that only values can be entered i.e. '1' or '2'.... and at the same time the question paper also mentions that to have a validation rule in the field 'Gender' that data should only be either 'M' or 'F' .... then .... how are both above instruction possible in the same database for the same table?
(3) If the above is a conflict then is the only solution to change the Field data type as Number and instead of entering 'M' or 'F' - it should either '1' or '2' where '1' = Male etc?
Your guidance will be highly appreciated.
Thanks
Regards / Pinesh Mehta
Re : MS Access 2013 Form - Radio Buttons - Gender Entry - M or F
I am not an expert with MS Access and hence posting a very basic question.
We are connected with education field and this doubt is worrying our students.
Unfortunately the school ICT teachers have neither attended to the doubt nor have solved it.
The students are asked to create Radio button in MS Access form for field 'Gender' where the data input is either 'M' or 'F'.
When we create radio buttons, it is allowing to enter values in the database table in numerical form only i.e. 1 for Male and 2 for Female.
Have the following doubts:-
(1) Can we enter thru the radio buttons - alphabets 'M' or 'F' in the database table instead of '1' or '2'? Does any such functionality exist in MS Access?
(2) If not and that only values can be entered i.e. '1' or '2'.... and at the same time the question paper also mentions that to have a validation rule in the field 'Gender' that data should only be either 'M' or 'F' .... then .... how are both above instruction possible in the same database for the same table?
(3) If the above is a conflict then is the only solution to change the Field data type as Number and instead of entering 'M' or 'F' - it should either '1' or '2' where '1' = Male etc?
Your guidance will be highly appreciated.
Thanks
Regards / Pinesh Mehta