numerical value to symbols

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hello all,

My question is a basic one - yet I am stumped as to how to accomplish
it! I am trying to generate a report in MS Access 2002 with the
following
basics:

a text field followed by 3 numerical values. That part is easy, but
here is where I am getting stumped. The numerical values range from 1
to 7. What I would like to display is a number line from 1 to 7, with
a symbol for each of the numerical values displayed at that point on
the number line... i.e.

1----2----3----4----5----6----7

text1 -----X-------O-----{}----------

text2 -----------------{}X------O----

(and so on down the page, with differing text and numerical values).

I would greatly appreciate any advice, suggestions or reference texts
that you think might help!!

mike
 
You could place three labels in your detail section with captions like X, O,
and {}. Add the numeric fields and make them invisible. Use the On Format
event to set the X position of the various labels
Dim intLeftMargin As Integer
Dim intSpacing as Integer
intLeftMargin = 1440 'one inch
intSpacing = 720 'distance between numbers
Me.lblOne.Left = intLeftMargin + Me.txtOne * intSpacing
Me.lblTwo.Left = intLeftMargin + Me.txtTwo * intSpacing
Me.lblThree.Left = intLeftMargin + Me.txtThree * intSpacing
 
Back
Top