comparing part of a text field in code 3

[MHadden]

Greetings All:
I have need to check a field to see if it contains the string "GEN" if it only contains this string the following code works great, however, almost all of the textboxes contain a 10 letter word & these three letters show up in some of them.
I have tried many different variations with no success. I'm posting now in hopes that someone can help.

Private Sub Form_Current()
  If [Product_Number].Seltext = "*GEN*" then
     frmProductsAvailable.IsVisible true
     else
     frmProductsAvailable.IsVisible False
     End If
  End Sub

Any help is appreciated!
- Michael

MichaelHadden@yahoo.com
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!

 

[SkipVought]

Hi,

  If [Product_Number].Seltext [b]Like[/b] "*GEN*" then

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[RoyVidar]

You are aware that the .seltext property of Access form controls only contain the selected text? To compare the whole text of the control, use the .Value property of the control (or don't specify any property, as the .value property is the default property).

Also - I'm lead to believe that the IsVisible property of controls, is only used/available in the on print event of reports? Should you get into problems, try:

[tt]frmProductsAvailable.Visible = true[/tt]

Roy-Vidar

 

[MHadden]

Thanks to both of you!!

Skip's code did work, but only after I changed "IsVisible" to "Visible", like Roy-Vidar said to do.

I haven't noticed a problem using SelText, so I didn't change it to Value, but I'm keeping an eye on it. Previously, when I tried it without specifying a property, it didn't work.

Either way, you both deserve a STAR & I thank you very much!

- Michael

MichaelHadden@yahoo.com
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!