option group check boxes and tables?

[pakerly]

Hello,
I have a form with an option group on it that has check boxes for
options. I want to take the value of the check boxes and put them into
my table.

for example I have:

__ MON
__ TUE
__ WED

and the value given to MON is 1, TUE is 2 WED is 3.

I have a field in my table called WEEKDAY: and I would like to be able
to add the actual words of the checkbox and not its vaslues to WEEKDAY
for example make it say MON or TUE or WED.

How would I do this?

thanks.

 

[John W. Vinson]

Hello,
I have a form with an option group on it that has check boxes for
options. I want to take the value of the check boxes and put them into
my table.

for example I have:

__ MON
__ TUE
__ WED

and the value given to MON is 1, TUE is 2 WED is 3.

I have a field in my table called WEEKDAY: and I would like to be able
to add the actual words of the checkbox and not its vaslues to WEEKDAY
for example make it say MON or TUE or WED.

How would I do this?

thanks.

Why would you WANT to do it?

Don't confuse data DISPLAY with data STORAGE. You can perfectly easily store
numbers 1 to 5 in the table, and display a text string - using an Option Group
bound to the number field, a Combo Box, a listbox, or joining to a little five
row table; it's not necessary to store the weekday name in the table to see
it.

 

[pakerly]

OK, could you explain then how would display the text, or day of week
text in a report instead of the value?