number in to different text boxes in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an employee database file. A record like a passport no (eg: 12345)
should print in different boxes in a report. This is for some form templates.
I had made a report according to the template given by some departments. In
their form passport number is to be typed in different boxes. Since my
passport no. record is singled field, how can I print it in different boxes
thru a report.

Thank your very much for your early response.

Regards,

Aja Mery Abraham
Saudi Arabia
 
On the on print section of the report where the text boxes of the passport
are, you can write the code

if condition then
me.passport1.ControlSource = "PassportNameFromTable"
else
if condition then
me.passport2.ControlSource = "PassportNameFromTable"
else
me.passport3.ControlSource = "PassportNameFromTable"
end if
end if

if you have several fields of passport just change the ControlSource to fit
your requirement
 
You must log in or register to reply here.

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

Access problem creating ACCESS query filtered by both check boxes and option groups. 0
A03 - count in report footer gives me #Error? 0
Populate Text Box from different source 2
Change text box background color depending on value in Label Reports 1
Show Parameter Information in Report Footer 1
sequentally numbering records in a report 2
Filtering Report Data 3
Columns in a report 1

Back
Top