View original (French)

Access: input mask for email/website

romain -  
 romain -
Hello,

I actually have several questions (two):

Email: I have my database on Access and I saw that thanks to the input mask we can enter a certain type of specific data,

anyway, I've tried several things like "CCCCCCCC"@"CCC"."CCC" or "aaaaaaaaa"@"aaaaaaa"."aaa"

but it’s very rigid, for example, the number of characters varies, and I have to have the same number of characters for each address which is completely useless.
So what I would like is for "@" to be displayed but for me to be free before and after to enter whatever number of characters I want,
thanks in advance

Website: second question similar to the first except that it concerns the website address
I would like "http://" to be displayed and for me to be able to freely enter the internet address

P.S.: I have also heard about validation functions but apparently you have to go through PHP so it’s not very practical

THANK YOU in advance if you have the solution

Configuration: Windows 7 / Firefox 17.0

1 answer

  1.
    Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 639
     
    Hello,

    Try #@#.CCC for emails and http://# for internet addresses. Set the field as a hyperlink if you want it to convert.

    --
    Remember remember the fifth of November
    Gunpowder, treason and plot.
    I see no reason why gunpowder, treason
    Should ever be forgot...
    2
    1. romain
       
      It didn't work at first, I put it in a hyperlink and it seems to take what I want.
      Now, do you know how to make it so that if I validate my input without "@" sometimes, it displays something?
      0
    2. Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 639
       
      Yes, in the field properties, you modify the "Message If Error" zone ^^
      0
    3. romain
       
      ok thanks ^^
      0