MaskedEdit

Ron · Joined: 04 Oct 2007 Posts: 201

Hi
I want to use the MaskedEdit box with 2 different formats,
1. (#####) ######
2. (####) #########
but store these in the same col of an Access DB, I have tried various ways
but all seem to hit problems, mostly with leading zero's which I need to keep
as this is for telephone numbers. No.1 for UK and No.2 for EU.

Can you help please ?

Ron

Archived from group: microsoft>public>vb>syntax

Jan Hyde · Joined: 04 Oct 2007 Posts: 1211

Ron 's wild thoughts were
released on Tue, 28 Nov 2006 06:59:01 -0800 bearing the
following fruit:

>Hi
>I want to use the MaskedEdit box with 2 different formats,
>1. (#####) ######
>2. (####) #########
>but store these in the same col of an Access DB, I have tried various ways
>but all seem to hit problems, mostly with leading zero's which I need to keep
>as this is for telephone numbers. No.1 for UK and No.2 for EU.
>
>Can you help please ?

And what type of field are you storing it in? Only
string\char type fields will preserve formatting.

Jan Hyde (VB MVP)

--
Orgasm : The gland finale (Stan Kegel)

Ron · Joined: 04 Oct 2007 Posts: 201

Hi Jan
I am using a Text Field, with an Input Mask, and I hoped to be able to
change the mask just before the vb data is sent to update the db. is this
possible or am I going about it the wrong way?

Ron

"Jan Hyde" wrote:

> Ron 's wild thoughts were
> released on Tue, 28 Nov 2006 06:59:01 -0800 bearing the
> following fruit:
>
> >Hi
> >I want to use the MaskedEdit box with 2 different formats,
> >1. (#####) ######
> >2. (####) #########
> >but store these in the same col of an Access DB, I have tried various ways
> >but all seem to hit problems, mostly with leading zero's which I need to keep
> >as this is for telephone numbers. No.1 for UK and No.2 for EU.
> >
> >Can you help please ?
>
> And what type of field are you storing it in? Only
> string\char type fields will preserve formatting.
>
>
>
>
>
> Jan Hyde (VB MVP)
>
> --
> Orgasm : The gland finale (Stan Kegel)
>
>