Fix Records with Two Spaces After a Period in 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.

Members

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.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Wildcard Search and LIKE: https://599cd.com/Like
• Update Queries: https://599cd.com/UpdateQ
• Replace Function: https://599cd.com/Replace

Links

• Product Catalog: https://599cd.com/ProductCatalog
• Status Box: https://599cd.com/Status

Recommended Courses

• Action Queries: https://599cd.com/ACX13

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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