Is it possible? 2

[shelton1979]

I have developed a rather complex access database. I have a handwritten form that's been used in the past before the system was created. i'm trying to continue to use the form as a hard copy while the data is in the database as well. With the form, it would be necessary to circle several choices. Is it possible to do this in a report in access? basically if a person says they're interested in bowling. I need to be able to have access circle the word in a report????

Thanks for any help you can give.!

 

[cghoga]

Could you use checkboxes instead?

 

[luceze]

This seems rather difficult but it worked for me. Draw a circle in Word or Excel. Copy and paste the circle in your report. Set the border style to none. Set the back style to transparent. Set the visible property to false. Place the circle over the control you wish to have circled. While the circle is selected click format/send to back.

To toggle whether the circle on or off, in the report's detail on format event make the circle's visible property to true or false based on the results of your report.

Example:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.YourFieldName = "Bowling" Then
Me.yourbowlingcirclesName.Visible = True
Else
Me.yourbowlingcirclesName.Visible = False
End If
End Sub

HTH,
Eric

 

[shelton1979]

i'm having some trouble with the If Me.YourFieldName = "Bowling" Then statement but it seems like it should work. thanks for your help.

 

[dhookom]

It is a bit difficult to answer if we don't know your data structure, sample data, and desired display. You can use the Circle method in your report's code to dynamically draw a circle/ellipse on your report. There is a kb article at

http://support.microsoft.com/default.aspx?scid=kb;en-us;210365&Product=acc

that shows explains how to draw the circle.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[SgtJarrow]

Great tip, Duane. Adding to my repository and giving you a star.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com