option bottoms

[gasx]

I have two option bottoms for male and female on my form.
the value for male is 1 and for female is 2.
when I select male I get 1 when I select female I get 2. I like instead of 1 and 2 get "X" when I print my pre printed form.

please help

 

[dzepeda]

Write this function in Global Code (Or Report Code if you use only one time)

Public Function RetornaSexo(MaleOrFemale as byte)

 If MaleOrFemale=1 then

'Male

    RetornaSexo="x"
 Else

'Female

    RetornaSexo=Space(10) & "x"

'Try different values for Space

 End If

End Function

In your Report add a text box, in data section, Control Source Property put :

=RetornaSexo(Gender)

Assuming Gender is your Data Source for Gender (1 or 2)


if you want to Add a third sex use Select Case in RetornaSexo Function