How do I put this "Press CTRL+APOSTROPHE (')" of Repeating the va.

T

Tony

How do I put this "Press CTRL+APOSTROPHE (')" of Repeating the value from the
Previous Record into the Visual Basic code or Macro?
 
J

John Vinson

How do I put this "Press CTRL+APOSTROPHE (')" of Repeating the value from the
Previous Record into the Visual Basic code or Macro?
Click to expand...

Well... don't. That's the hard way to do it!

Instead, set the Default value of each control in the AfterUpdate
event of the control:

Me!txtMyTextbox.DefaultValue = Chr(34) & Me.txtMyTextbox & Chr(34)


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
WORD VBA Search and switch to advanced ... 1
Control apostrophe 1
Insert the data from the same field in the previous record CTRL+' 3
Shortcut Keys CTRL+APOSTROPHE events 2
Opening client form with apostrophe in name 2
SendKeys 3
Other form of CTRL+APOSTROPHE (') 7

Top