🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #467

Re: help with form/table automatic entry

#467
From: JLindsay
Date: Thu, 10 Jul 1997 00:00
43 lines
2208 bytes
Robert:
The input mask does not need to be created on the form design 
property sheet. You can do it in code as part of an event 
procedure for the control that defines it. Assume that you are 
getting some information that defines the input mask in txtONE, and 
you want to set the input mask in txtTWO.

In the LostFocus event of txtOne, set the property txtTWO.Inputmask 
to the correct construction.
 HTH
JLindsay

Robert Bote wrote:
> 

> How about when the entry is made up of text from other controls on the
> same form.  I am having trouble piecing the text together when I am at a
> new record...
> 
> txtFullText = [cboPart1] & "_" & [txtPart2] & "text" & [txtPart3] &
> ".txt"
> 
> Ron Myer wrote:
> 
> > TIMOTHY W. NEWTON wrote:
> > >
> > > I have a table that use a long entry. The first part of the entry is
> > alway
> > > "R" followed by eleven numbers (changes each entry) then "UNOFSAND"
> > > followed by seven more numbers. How can I make it so the "R" and
> > "UNOFSAND"
> > > are alway there and all have to do is type the other numbers in on
> > the form
> > > and it saves it to the table. Pls help. Pls email answers to
> > > enforcer@pacbell.net.  Thanks.....
> >
> > Hi,
> >
> > Use an Input Mask to do this task!
> >
> > hth,
> > Ron Myer
Technical Details
Message-ID: <33C4D865.401A@notme.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bc8bc9$b2c566e0$1575aace@adp547> <33C2C958.3DF9@ix.netcom.com> <33C41B2A.F3344650@earthlink.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,636d2ef524c2aa6f
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,636d2ef524c2aa6f
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1041a7,636d2ef524c2aa6f
X-Google-Attributes: gid1041a7,public
X-Google-Thread: ff0ac,636d2ef524c2aa6f
X-Google-Attributes: gidff0ac,public
X-Google-Thread: ffa7b,636d2ef524c2aa6f
X-Google-Attributes: gidffa7b,public
From: JLindsay <Jim@notme.net>
Subject: Re: help with form/table automatic  entry
Date: 1997/07/10
Message-ID: <33C4D865.401A@notme.net>
X-Deja-AN: 255948110
References: <01bc8bc9$b2c566e0$1575aace@adp547> <33C2C958.3DF9@ix.netcom.com> <33C41B2A.F3344650@earthlink.net>
Organization: ADG
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.tablesdbdesign,microsoft.public.msaccess.chat