changing label caption by user input

I have a combo box that I have written code to change a labels caption
depending on what the user selects from the combo list. it works right until
the last item in the list is chosen...it doesn't change. This is the code
that I am using

If cmbSavType.Value = "1) Last Year" Then
lblBase.Caption = "Prior:"
ElseIf cmbSavType.Value = "2) Other Levels" Then
lblBase.Caption = "Market:"
ElseIf cmbSavType.Value = "3) Inflation" Then
lblBase.Caption = "Inflated:"
ElseIf cmbSavType.Value = "4) Lowest" Then
lblBase.Caption = "Lowest:"
End If

the obvious answer would be that the last item isn't exactly

"4) Lowest"

so it doesn't pass the test and take the action to update the label.

there may be an extra space in there somewhere.

--
Regards,
Tom Ogilvy


"juliejg1" wrote:

> I have a combo box that I have written code to change a labels caption
> depending on what the user selects from the combo list. it works right until
> the last item in the list is chosen...it doesn't change. This is the code
> that I am using
>
> If cmbSavType.Value = "1) Last Year" Then
> lblBase.Caption = "Prior:"
> ElseIf cmbSavType.Value = "2) Other Levels" Then
> lblBase.Caption = "Market:"
> ElseIf cmbSavType.Value = "3) Inflation" Then
> lblBase.Caption = "Inflated:"
> ElseIf cmbSavType.Value = "4) Lowest" Then
> lblBase.Caption = "Lowest:"
> End If

that fixed it. thnx1

"Tom Ogilvy" wrote:

> the obvious answer would be that the last item isn't exactly
>
> "4) Lowest"
>
> so it doesn't pass the test and take the action to update the label.
>
> there may be an extra space in there somewhere.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "juliejg1" wrote:
>
> > I have a combo box that I have written code to change a labels caption
> > depending on what the user selects from the combo list. it works right until
> > the last item in the list is chosen...it doesn't change. This is the code
> > that I am using
> >
> > If cmbSavType.Value = "1) Last Year" Then
> > lblBase.Caption = "Prior:"
> > ElseIf cmbSavType.Value = "2) Other Levels" Then
> > lblBase.Caption = "Market:"
> > ElseIf cmbSavType.Value = "3) Inflation" Then
> > lblBase.Caption = "Inflated:"
> > ElseIf cmbSavType.Value = "4) Lowest" Then
> > lblBase.Caption = "Lowest:"
> > End If