[Access] Automatically filling a field - Tilted Forum Project Discussion Community

bltzkriegmcanon · 11-05-2004, 09:32 AM

Hey guys, I need to ask a (hopefully) quick question. I'm trying to set up a form so that data from a user's input in a text box will automatically go into another text box after the user has input it into the first text box. What I'm trying to get done here is input the VIN of a vehicle in one text box, and then the last 6 digits of that input will go into a text box on that same form. Is this possible without involving another table or creating a field on that same table, or creating a subform?

Thanks in advance for any help that can be given.

P.S. I have another question. As usual. How can I set a query's input field to be limited to a certain number of characters, or a certain type of input (alpha/num)? As in, a user can only input so many characters in the query or the user gets an error message, as opposed to no results showing.

tinomen · 11-05-2004, 10:39 AM

Question 1: Create an AfterUpdate event for the first textfield and use the Right function. Something like this:

Code:

Private Sub Text1_AfterUpdate()
    Text2.Text = Right(Text1.Text, 6)
End Sub

Question 2: Use the Input Mask property. It can limit characters and type of characters. The appropriate help reference can be found under Valid input mask characters

bltzkriegmcanon · 11-10-2004, 05:32 PM

Ok, I tried what you suggested, but then I got the following run-time error:

Run-time error '2185':

You can't reference a property or method for a control unless the control has the focus.

So what should I do?

tinomen · 11-11-2004, 08:38 AM

Dumb me. Change Text2.Text to Text2.Value

11-05-2004, 09:32 AM	#1 (permalink)
bltzkriegmcanon Holy Knight of The Alliance Location: Stormwind, The Eastern Kingdoms, Azeroth	[Access]/[SQL] Automatically filling a field Hey guys, I need to ask a (hopefully) quick question. I'm trying to set up a form so that data from a user's input in a text box will automatically go into another text box after the user has input it into the first text box. What I'm trying to get done here is input the VIN of a vehicle in one text box, and then the last 6 digits of that input will go into a text box on that same form. Is this possible without involving another table or creating a field on that same table, or creating a subform? Thanks in advance for any help that can be given. P.S. I have another question. As usual. How can I set a query's input field to be limited to a certain number of characters, or a certain type of input (alpha/num)? As in, a user can only input so many characters in the query or the user gets an error message, as opposed to no results showing. __________________ What do you say to one last showdown? - Ocelot, Metal Gear Solid 3 The password is "Who are the Patriots?" and "La-Li-Lu-Le-Lo." "La-Li-Lu-Le-Lo." Gotcha. - The Colonel and Snake, Metal Gear Solid 3 Last edited by bltzkriegmcanon; 11-05-2004 at 09:42 AM..

11-05-2004, 10:39 AM	#2 (permalink)
tinomen Upright	Question 1: Create an AfterUpdate event for the first textfield and use the Right function. Something like this: Code: Private Sub Text1_AfterUpdate() Text2.Text = Right(Text1.Text, 6) End Sub Question 2: Use the Input Mask property. It can limit characters and type of characters. The appropriate help reference can be found under Valid input mask characters

11-10-2004, 05:32 PM	#3 (permalink)
bltzkriegmcanon Holy Knight of The Alliance Location: Stormwind, The Eastern Kingdoms, Azeroth	Ok, I tried what you suggested, but then I got the following run-time error: Run-time error '2185': You can't reference a property or method for a control unless the control has the focus. So what should I do? __________________ What do you say to one last showdown? - Ocelot, Metal Gear Solid 3 The password is "Who are the Patriots?" and "La-Li-Lu-Le-Lo." "La-Li-Lu-Le-Lo." Gotcha. - The Colonel and Snake, Metal Gear Solid 3

11-11-2004, 08:38 AM	#4 (permalink)
tinomen Upright	Dumb me. Change Text2.Text to Text2.Value