Need validation rule and/or code for multiple website entries

[LeiDBug007]

Greetings,

I need a code or validation rule that will allow the user to include multiple hyperlink/website entries in a field.

For example: "

http://www.yahoo.com;

http://www.msn.com;

http://www.lycos.com"

My field properties has it set-up to auto hyperlink their entries (e.g.: Yes on "Hyperlink" property), but once they enter multiple sites with semi-colons as the separators or even with or without separators -- it's invalid 'cause it's taking the multiple entry as one whole hyperlink, not separate listed links.

Your expertis is needed. Thanx!

 

[GTLoco99]

What version of Access are you using


Thanks
Glen

 

[LeiDBug007]

To Glen,

We are using Access 2000. Thanx!

 

[docmeizie]

Each field is only meant to hold one element of data related to that record. This being state two options are available: 1) Add more fields to accomodate the other articles of data, or 2) Create a table that is linked to your current table but only holds website information and a relevant key for linking to the or main table.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv