Print Report Question

[Guest]

I have a report I need to print that is an application form. I have a type
field that has a possible 5 different entries "Y", "G", "E", "A", or "R".
It's a 1 character text field. What I'd like to be able to do is print an X
in the box beside the appropriate label based on the entry in the application
form. Any suggestions as to how to do this would be appreciated.

Thanks,
Randy M

 

[Guest]

Try this --
Add 5 textboxes using the fields as control source. Edit control source
like this --
=IIf([YourField] = "Y", "X", "")
Do the same for the other textboxes substituting G, E, A, & R.
Create a rectangle and place over the textboes. Set the Back Style to
Transparent.

 

[Guest]

Thanks Karl for the help. I'll try that.

Randy M

Try this --
Add 5 textboxes using the fields as control source. Edit control source
like this --
=IIf([YourField] = "Y", "X", "")
Do the same for the other textboxes substituting G, E, A, & R.
Create a rectangle and place over the textboes. Set the Back Style to
Transparent.

I have a report I need to print that is an application form. I have a type
field that has a possible 5 different entries "Y", "G", "E", "A", or "R".
It's a 1 character text field. What I'd like to be able to do is print an X
in the box beside the appropriate label based on the entry in the application
form. Any suggestions as to how to do this would be appreciated.

Thanks,
Randy M