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

- Tilted Technology (https://thetfp.com/tfp/tilted-technology/)

- - [Access] Automatically filling a field (https://thetfp.com/tfp/tilted-technology/75028-access-automatically-filling-field.html)

[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.

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

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?

Dumb me. Change Text2.Text to Text2.Value