How to Use the Replace Function in Microsoft Access

In this episode, we're going to look at the Replace function in Microsoft Access. This handy little function can really help you out when you need to change things like product names, or give alternate views to certain values in a table. You can use this function in queries, forms, reports, expressions, and VBA code, making it a very flexible addition to your MS Access toolkit.

Related Videos:
Getting Started with MS Access Visual Basic for Applications - VBA Code-Behind and Modules
VBA MsgBox - How to use message boxes in MS Access
How to Use a Do Until Loop in MS Access VBA
How to Use Iif in Microsoft Access
How to Use the Replace Function in Microsoft Access
You are watching this video now!
How to Use Nz in Microsoft Access to Handle Null and Empty Values
Iif, If Then Else, and Select Case in MS Access
How to Use DLookup in Microsoft Access
How to Create and Configure a Custom Pop-Up Form in MS Access

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#msaccess #vba

[jillybeanc]

Question. I have a Table that includes 7 columns for the days of the week. The table data is pulled from a report where it just shows a "Y" in that days column if the course (I work at a school) is taking place on that day. Is there a way to have it change to the letter of the day instead. For instance, if a course is taking place on Mondays, I would like to have an M show instead of a Y when I run that query. I have built separate tables for each day to look for a Y and replace it with a letter but that's 7 different tables that I have to connect every time and I know there has to be an easier way. Any help would be awesome.

[garythedo]

Hi, really great videos! I was wondering if you might do one in the future on the SelStart property to move the cursor to a particular spot in a text box string and then add new (or replace text) at that location?

[gwnroch]

Would have preferred to see the VBA code so I can turn this into a function

[nycbklynrmp]

had an issue, if use replace with group and contion succh as like

eg reason for visit *well care*, *well visit, * wcv * were strings to find in text
however wanted to replace ‘swell’ to ‘’nothing because I don’t want to match on swell, or swelling

in query design

replace(x, “swell”, “”)
group
critreria : like *well care*

[mukeshmishra]

How to insert automatic text from drop-down when I edit or modified or update in any row

[mukeshmishra]

How to control duplicate data in two fields in ms access form