Assigning Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have two unbound textboxes on my report. Txt1 and txt2.
Txt1's value is filled based on a a selection made from a list box on a
form, for example "January"

Txt2's value must be assigned, based on what the value of txt1 is.

I used a series of iif statements in txt2 that said if txt1 = "x" then "y".

Problem: I am getting leading and trailing zero's which are throwing my
numbers off.

Can anyone give me a reason why this is happening or offer a better way of
doing this?

Many thanks,
 
It's near impossible to even guess since we don't have a clue how you are
assigning any values and where the zeros are coming from.
 
Back
Top