Warn users of forgotten URLs in hyperlink fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

seaton - 13 Sep 2007 01:37 GMT

Hello, everyone.

Sorry if this is a terribly basic question, but how do you set up a hyperlink
field so that the user will be warned if it does not include a URL? I ask
because I have a situation where users regularly enter the display text for
the hyperlink field, but forget to add the URL that goes along with it, and
then simply move on to the next record.

I'm thinking that an input mask may solve this problem, but what is the most
flexible way to write an input mask for general URLs? (Web sites only, no
network paths or anything like that.)

With many thanks in advance,

seaton

Reply to this Message

Wayne-I-M - 13 Sep 2007 08:24 GMT

Not sure - never done it. But think you could use something like in the
beforeupdate

If Me!TextBoxName Not Like "*.com*.*" Or Me!TextBoxName Not Like
"*.co.uk*.*" Then
MsgBox "You must add the the URL", vbOKOnly
Cancel = True
End If

Although I think there is almost certainly a better way of doing this - no
time at the moment - someone else may give a better answer but this should
set you on the right track.

Good luck

Signature

Wayne
Manchester, England.

> Hello, everyone.
>
[quoted text clipped - 11 lines]
>
> seaton

Reply to this Message

seaton - 13 Sep 2007 09:56 GMT

Thank you, Wayne-I-M!

That seems like something that might work (I keep getting error messages at
the moment, but should be able to work those out). I'm thinking that Not Like
"*http://*.*" should work, because that's the part all URLs need to have.

Thanks again!

>Not sure - never done it. But think you could use something like in the
>beforeupdate
[quoted text clipped - 16 lines]
>>
>> seaton

Reply to this Message