How to Fix Records Where Users Typed Two Spaces After a Period in Microsoft Access

In this Microsoft Access tutorial I'm going to teach you how to fix records where users typed in two spaces after a period. We'll use an Update Query and the Replace function.

Ethan from Romeoville, Illinois (a Platinum Member) asks: I keep my product database in Microsoft Access and with the help of your lessons I print out my catalog directly from the database. Unfortunately a lot of my data entry people are old school and have typed two spaces after a period in a lot of the different fields. Is there any way that I can go through and edit that automatically without having to manually find and replace everything? And I know it's going to happen in the future again because I've yelled at these guys a million times so an automated solution would be nice.

Silver members and up get access to an Extended Cut of this video. Members will learn a completely automated one button click solution where we will count the number of records that need to be fixed and inside a loop fix them, count again, rinse and repeat.

MEMBERS-ONLY EXTENDED CUT VIDEO:

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Fix 2 spaces after period, How do you change spacing after a period, two spaces at end of sentence

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[Shadow.Dragon]

I don't use the Update Query very often, so it good to see it in order to refresh my memory! Thanks for the video Richard and I hope you get well soon!

[ncexpress]

Two spaces after a period and the Oxford/serial comma in a list. Anyone that wants to argue can meet me by the dumpster behind the Taco Bell of their choice. Seriously, no one will ever be able to convince me otherwise, but I get the need for this technique and greatly appreciate these videos!

[דודקלדרון-כפ]

I usually use the simple "find and replace" method and it works like a charm.

[jerrydfowler]

With just a little change that would work for finding double spaces within a sentence? The weird part is if some use 5 spaces instead of a tab. Or is there a reason some might use more than one space in a sentence?

[aymking]

In the combo box with milti selection. How I can recall the multi selected item?