Results 1 to 2 of 2

Thread: Symbol

  1. #1
    Join Date
    Sep 2005

    Unanswered: Symbol


    In VB Code,

    if ([Vendor Name] <> [VN]) then

    End if

    <> symbol doesn't work. What symbol is for NOT Equal string?


  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Yes, but strings (such as VN) have to be enclosed here, as in most languages, within double quotes! If [Vendor Name] is a valid control name, then

    If [Vendor Name] <> "VN" then
    ...your code goes here
    End if

    should work. BTW, you only really to use square brackets if your control name has spaces in it. Preferred practice sez never have spaces in control names, unless you're redoing an app or importing data where this was done.
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts