ms accesss option group on report

[bobbyer]

A list of all jobs performed is maintained in a log report binder that go back decades. (356 pages and counting) The real old jobs are unassigned and coded 99 just so the field isn’t left empty. The newer jobs are coded 1-7 via an option box on the job input form.
When a new job comes in, all of its job info is handwritten on next line of the log including making one selection for the type of job. (There are 7 columns on the print out and only one can be checked)
Here is a sample of the heading on my report
JOB# CLIENT LOCATION Type1 Type2 Type3 Type4 Type5 Type6 Type7
X
The job info is then entered in an Access form that contains an option box that handles the 7 job types so that the user can only select one. Once done, only the last page of the log needs to be reprinted.
My question is:
How do I get the option box to display all of its options in a report like above?
I tried 7 unbound text boxes and using a Select Case on the OnFormat event but all seven of the boxes get checked for each job.

 

[Andrzejek]

How do I get the option box to display all of its options in a report like above?

I don't think you want it to look like this, do you:
JOB# CLIENT LOCATION Type1 Type2 Type3 Type4 Type5 Type6 Type7
X

I would assume you want something like this, right?[pre]
JOB# CLIENT LOCATION Type1 Type2 Type3 Type4 Type5 Type6 Type7
X[/pre]

Click 'Preview' before 'Submit Post' to see how your post will actually look like.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[bobbyer]

you're right. I will preview from now on

 

[dhookom]

I expect you can use an option group bound to the field storing the 1-7 value.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[bobbyer]

Thanks Duane. I did try an option group before but didn't understand how it worked on a report. (I've only dealt with them on a form.) I imagine it's similar to using a combo box and being able to select columns. I'll give it a shot.