Results 1 to 10 of 10
  1. #1
    Steven.Allman is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2010
    Posts
    101

    Validation Rules, I just dont want any damned comma's in the text field

    You would think this could be found in a 2 second google search, but NOOOOO. Ive read on validation rules to require phone numbers have (###)-###-#### format or it sends a warhead to your computer and drains your bank account, but I just want those who cant read the tooltip, or the 48 point font note (IM NOT MAKING THAT UP, 48 POINT) on the sharepoint list itself to stop putting Last, First in the name field.


    I need validation rule that requires LAST FIRST M
    Done, end. CAPS NO COMMA..
    :-)
    Attached Thumbnails Attached Thumbnails list.jpg  

  2. #2
    Steven.Allman is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2010
    Posts
    101
    Click image for larger version. 

Name:	form.jpg 
Views:	21 
Size:	11.5 KB 
ID:	43614Form... still get daily input with Last, First

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    827
    Why not make it 3 required fields?
    I'm not sure what your business needs are but it sure makes it easier than having to parse it out later on.
    What if there is no middle name or its not known?
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,567
    Why not make it 3 required fields?
    I'll bet they'll put first,last in either first or last, or even both!
    One could use Instr function in Before Update event on those controls. If you find a comma, raise message box and cancel the update. They'll soon tire of being stuck in one place.

    @moke123
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  5. #5
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,687
    Three separate fields is by far the best solution.
    If you really must stick with your current design, why not clearly state NO COMMAS?
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

  6. #6
    Steven.Allman is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2010
    Posts
    101
    Quote Originally Posted by isladogs View Post
    Three separate fields is by far the best solution.
    If you really must stick with your current design, why not clearly state NO COMMAS?

    You must not have see my attached images. Everywhere its input it clearly states no comma's.
    But..... yeah..

  7. #7
    Steven.Allman is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2010
    Posts
    101
    SharePoint list input. I manage through an access DB, but this input is done by the user on a sharepoint list, so Before Update isn't an option.

  8. #8
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,687
    Quote Originally Posted by Steven.Allman View Post
    You must not have see my attached images. Everywhere its input it clearly states no comma's.
    But..... yeah..
    I looked at both your screenshots. Neither of them states no commas.
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

  9. #9
    Welshgasman is offline Expert
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    622
    Quote Originally Posted by Steven.Allman View Post
    You must not have see my attached images. Everywhere its input it clearly states no comma's.
    But..... yeah..
    Clear to you perhaps?
    It does not even say anything about Caps?, are we meant to infer that just by the LAST FIRST MI ?

    Nothing to stop you converting to Caps and replacing comma for a space, two spaces for one, but cannot see how you could stop them entering First then Last?

    Comes down to the old adage, discrete items of data should be stored separately.?
    Please, please use # when posting code snippets.
    Cross Posting Etiquette: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



  10. #10
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,567
    so Before Update isn't an option.
    But Replace function is? Clean up after if you can't prevent.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. fiield validation rules
    By Jen0dorf in forum Access
    Replies: 1
    Last Post: 08-27-2017, 12:42 PM
  2. Validation Rules
    By hinkwale in forum Access
    Replies: 2
    Last Post: 01-21-2015, 07:06 PM
  3. Validation Rules Help
    By Troop in forum Access
    Replies: 11
    Last Post: 03-05-2013, 01:26 PM
  4. Field rules/validation rules
    By sk88 in forum Access
    Replies: 14
    Last Post: 02-26-2012, 01:03 PM
  5. Validation Rules
    By esglover in forum Database Design
    Replies: 1
    Last Post: 07-23-2010, 08:02 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 - Senior Forums