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,
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,