• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

VB coding in an Access report

I don't belong to tthat other list so I will post an answer here I hope will help.

Some of the replies I saw were headed in the right direction I think.

First what type of control are you using to show the picture?

I believe whatever code you need to write should be placed in the on format section or the detail section

the code should be something that sets the image to display (yeah obvious but stick with me). Try looking at the various properties of the image contro you are using on the report.
look for one where you define the image. type in the path to the image (dont worry abotu getting it to work dynamicaly yet). Once you have figured out the right control & the right information to supply to the control you should be able to accomplish what you wish.

whatever that property is on the control it should be as easy as placing the field name from the data source (a query or the table) that corresponds to the images you are trying to dispay.

My guess is that the code will look something like control.recordsource = [field contents]

I.e. to get a text box to dispaly the text in a field it look someting like txtSample.value = [Samplefield].

Hope this helps

AlricTheMad
 
PM me if you still need help with this. I made up a db that does what you want, I can email it to you. Access 2K.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top