Can I copy and paste automatically in forms?

G

Guest

I have a photo database and, once I've entered the PhotoName in the
appropriate box, I would like it to magically appear in the link box that
contains the path to the photo. Eg: c:\My Documents\My Photos\[PhotoName].jpg
 
J

John Vinson

I have a photo database and, once I've entered the PhotoName in the
appropriate box, I would like it to magically appear in the link box that
contains the path to the photo. Eg: c:\My Documents\My Photos\[PhotoName].jpg
Click to expand...

Set the Control Source of that textbox to

= "c:\My Documents\My Photos\" & [PhotoName] & ".jpg"


John W. Vinson[MVP]
 

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

Bound Object Frame in form 1
Appending value to a second field. 1
How do I send a file by email via VBA? 1
Photos linked to an Access Form 3
How display digital camera photo on form and print on report? 2
Inserting Image in Form 1
Image control on form - not displaying the image stored in a file 8
Images in Forms and Reports 2

Top