Avatar of Stephen Roesner
Stephen Roesner
Flag for United States of America

asked on 

Grabing a specific String of 16 chars within a text field

I have a Notes Field. It might contain the words "Drug List ######" the numbers can be different 6 numbers and the 16 chars can be anywhere in the field. Is there a way to grab it by itself? I tried Instr but I couldn't figure out a way to grab the 16 chars. Any Ideas?

Microsoft AccessVBA

Avatar of undefined
Last Comment
Stephen Roesner

8/22/2022 - Mon