Form questions

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

Guest

Hello everybody. I have some questions about Access 2003 forms. If I fill in
a record, then another one, and so on, when I try to print a specific record
it prints all the records stored... How can I print only ONE record? Another
thing, I've selected to print only the data on the fields, and it works, but
it also prints a horizontal line at the end of the field. Why?!
One last thing: is it possible to convert a number to text? Like, I type a
value into a field, and I need another field to auto update with this value
written in text.
Thank you all.
 
Hello everybody. I have some questions about Access 2003 forms. If I fill
in
a record, then another one, and so on, when I try to print a specific
record
it prints all the records stored... How can I print only ONE record?
Click to expand...

Use the button wizard...there is a option to print only the current form.
Another
thing, I've selected to print only the data on the fields, and it works,
but
it also prints a horizontal line at the end of the field. Why?!
Click to expand...

There might be something set on the field. Really, at the end of the day,
dump the idea of trying to print the form, and build a report with all nice
formation, and stuff you want. A great developer tip here:

Forms are for data entry, not printing data

Reports are not for data entry, but are great for printing of data.

So, ignore my first advice about using the wizard..as I had not yet read
your 2nd problem!!

The approach to print ONE record to your very nice report (that you will
make) is

The code behind a button will look like to print the current record:


me.Refresh ' save record to disk before we print it

docmd.OpenReport "myCoolReprot",acViewPreview,,"id = " & me!id

The above assumes you have a primary key field of id
 
Back
Top