Using VBA to skip fields

(1) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

I would like to have the cursor automatically skip a few fields after the user enter a purchases amount on the Payables Transaction Entry screen. I thought this would do the trick but I get "Invalid Object" message.

Private Sub Purchases_AfterUserChanged()

Console.Writeline ("\t")

End Sub

What is the correct syntax to output a tab character so that it will skip a field.

*This post is locked for comments

All responses (3)

Answers (0)

Tim Foster 8,515 on at

Like (1)

Report

RE: Using VBA to skip fields

For future reference the VBA Command to Send the tab keystroke

SendKeys Chr(9)

or some blogs say this

SendKeys "{TAB}"

Tim
Suggested answer

Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: Using VBA to skip fields

VBA does not have a console object but the focus code works. The users want to go directly to the check field after enter the purchases amount. me.Check.Focus does the trick. Thanks.
Suggested answer

Tim Foster 8,515 on at

Like (1)

Report

RE: Using VBA to skip fields

You could try:

Console.Writeline (chr(9))

Why not just set the focus on the object?

me.somefield.focus

Tim