Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2004
    Location
    Louisville, Kentucky, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find Text Function (Access 2000)

    Is there a function in access that will return the character number of a specfic character in a field like the "Find" function in excel?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find Text Function (Access 2000)

    You can use the VBA function InStr. In a query:

    PositionOfC: InStr([NameOfField], "C")

    Or in the control source of a text box on a form or report:

    =InStr([NameOfField], "C")

Posting Permissions

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