Custom Data Entry Filter Functons in Access

Presenter: Richard Rost, Access Learning Zone

Have you ever wanted to allow the pasting in of data from another source into Access, while preserving input formats? In this presentation, Access MVP Richard Rost is going to show how to write very useful functions to filter out unwanted characters from a text field (or string) in Microsoft Access.

For example, you can force users to enter only digits into a phone number field by setting up an Input Mask. However, what if you want to copy and paste from emails and such. That doesn't work with an Input Mask. How can we allow the user to paste a phone number into the field and then just remove anything but the digits?

Richard Rost is an Access MVP and the owner of Computer Learning Zone, a technology education firm based in Florida. Richard has been teaching software courses since 1994, and was an Access MVP in 2014 and 2015. He has an extensive online library of Access training videos at his YouTube channel at https://www.youtube.com/599cd.

Join us online at 6:30 PM Mountain on Thu Jul 20! https://us02web.zoom.us/j/73524628389?pwd=UWtpZ1piLzhXTEtSRVpnaTA0OEpMUT09

Got an Access question or just want to network? Join us online at 6:00 PM, before the presentation!