[AccessD] masking question

Heenan, Lambert Lambert.Heenan at AIG.com
Wed Feb 9 08:57:20 CST 2005


I see a couple of us have spotted the Octal thing.

Someone suggested yesterday that you have four textboxes for each octet of
the IP address. If you did that then you could have "###" as the mask for
each box and then run a simple function like

Function StripZeros(ByVal TextIn As String) As String
   While left(TextIn, 1) = "0"
      TextIn = Mid(TextIn, 2)
   Wend
   If TextIn = "" Then TextIn = "0"
   StripZeros = TextIn
End Function


in each textbox's LostFocus event, or simply when you hit the button to run
Ping.

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
> Sent:	Wednesday, February 09, 2005 8:55 AM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] masking question
> 
> I don't want leading zeros though...this gives really odd results. If
> you were to type, "ping 010.011.196.017", you are not going to ping the
> intended address, but rather 8.9.196.15
> 
> I don't understand this myself...I'm trying to investigate what is
> actually happening on the network side of things, but either way, it
> means I can't store this way. Well, I could, but it would be confusing.
> 
> >>> stuart at lexacorp.com.pg 2/8/2005 5:34:57 PM >>>
> On 8 Feb 2005 at 14:46, John Clark wrote:
> 
> >> 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?  
> 
> > Yeah...I've actually been contimplating this myself. It would
> probably
> > make sorting easier as well.
> > 
> So would forcing the leading zeros with "000.000.000.000"
> 
> -- 
> Stuart
> 
> 
> -- 
> 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



More information about the AccessD mailing list