[AccessD] masking question

Yeah...I've actually been contimplating this myself. It would probably
make sorting easier as well.

>>> dwaters at usinternet.com 2/8/2005 2:36:23 PM >>>
John,

I would guess that as the numbers are entered, the IP address is being
thought of as 4 different pieces of data.  So, if you just used 4
textboxes
with sequential tab order and put periods between them, would that
work?  

On a report it could look better, or you could concatenate the 4 fields
and
three periods to be displayed in one textbox.

Just my first thought . . .

Dan Waters
ProMation Systems

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Tuesday, February 08, 2005 1:15 PM
To: accessd at databaseadvisors.com 
Subject: [AccessD] masking question

This is probably an Access 101 question, but I don't get it.

I was trying to whip up a quick database to track all of our network
equipment. I basically want to track our servers, switches, and
routers.
One of the fields is for the IP number of the item. I wanted to enter
in
the form of 255.255.255.255 but I am having some difficulty, which
this...what I thought to be...simple task.

I am using a mask of "009.009.009.009" but if I don't use up the
spaces, I get "10 .10 .133.  3" and I want it to look like
"10.10.133.3"

What I think I have to do, and have proceeded that way, is to make the
mask "CCCCCCCCCCCCCCC" and input the "."s myself. This isn't the end
of
the world...it is just something we'll be using in-house...but I was
just curious as to a work around.

Thanks 

John Clark
-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com