Results 1 to 5 of 5
  1. #1
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60

    About email and web site entry mask

    Hello,

    I created text area like "area1" in my table. Later I created form and I want to use this area1 for email or website entry. I don't want to link, so I want to only "small letter" entry. I tried < operator entry mask but it didn't work for "." and "@" symbols. How can I record this email and web site informations (with small letter) to my table? Thank you..

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    use the afterupdate event to set it to lower case:

    Code:
    sub txtArea1_afterupdate()
    txtArea1 = lcase(txtArea1)
    end sub

  3. #3
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60
    Thanks ranman256..

  4. #4
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60
    Hello again

    Yes runman256 your solution is working. But some languages are including "İ" and it doesn't work for "İ". How can I solve it?

  5. #5
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60
    Hello again,
    I solved it. For example in Turkish alphabet, we can use this codes for text area after update;

    Code:
    metin = LCase(Replace(metin, "İ", "i"))
    metin = LCase(Replace(metin, "ı", "i"))
    metin = LCase(Replace(metin, "Ö", "o"))
    metin = LCase(Replace(metin, "Ş", "s"))
    metin = LCase(Replace(metin, "Ü", "u"))
    metin = LCase(Replace(metin, "Ç", "c"))
    metin = LCase(Replace(metin, "Ğ", "g"))

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

Similar Threads

  1. Time Entry with Input Mask
    By Jxsmith in forum Forms
    Replies: 6
    Last Post: 05-03-2018, 04:26 PM
  2. Replies: 1
    Last Post: 03-17-2017, 11:52 AM
  3. Can you display your ERD on this site?
    By jpanther36 in forum Access
    Replies: 1
    Last Post: 08-02-2016, 03:27 AM
  4. How to change email address on the site?
    By djclntn in forum General Chat
    Replies: 1
    Last Post: 11-05-2015, 06:27 PM
  5. Replies: 5
    Last Post: 05-07-2014, 09:25 AM

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