Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    You're welcome. Some seem to confuse the purpose of BeforeUpdate - as though you have to use all of what it provides. Entering data then correcting it may work but it's poor practice. Better to validate and prevent bad data entry rather than hope you can fix it.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  2. #17
    zdjbel is offline Advanced Beginner
    Windows 11 Office 365
    Join Date
    Apr 2012
    Posts
    42
    I agree, that approach is the most sensible one. The best solutions are the simplest ones that work.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Find (not replace) spaces in a text field
    By catluvr in forum Queries
    Replies: 2
    Last Post: 03-08-2023, 12:36 PM
  2. Replies: 4
    Last Post: 08-27-2016, 03:25 PM
  3. Replies: 2
    Last Post: 07-09-2014, 06:41 PM
  4. Pasting formatted text into memo field
    By joekuhn in forum Access
    Replies: 0
    Last Post: 07-08-2011, 02:01 PM
  5. Deleting Spaces
    By grgerhard in forum Import/Export Data
    Replies: 2
    Last Post: 04-30-2006, 06:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums