Reference to Text field and display information.

[paul123456]

I have some reports that i would like to display different data depening on what the first two letters of a field are.. IE if the field starts with TX i would like to display a different ="text " field in the report but if it starts CA then it displays ="differenttext"?? how can i go about doing this? this will save me from having to create 2 of the same reports with different wording.

Thanks, PAUL

 

[mgolla]

Here is what I would do:

1) Have the text field hidden on the report

2) Add a label and place it where I want the text field displayed

3) Put this code in the On Format event of the report detail

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Select Case Left(YourField,2)
        Case "TX"
            YourFieldLabel.Caption = "Texas"
        Case "CA"
            YourFieldLabel.Caption = "California"
    End Select

End Sub

HTH
Mike

[penguin] Dooobie...Doobie......Dooo

Beware the penguins

 

[paul123456]

I made it a little easier for me..i created a field called state codes..

i want to do this...IIF([Statecode]=CA,California) or IIF([stateCode]=TX,Texas)

if statecode is equal to ca then display california..and if statecode =tx then display texas as text???

am i close?

Thanks, PAUL