how to hide id from form in report to print (1 Viewer)

SalmanZeiad

Member
Local time
Today, 22:51
Joined
Oct 30, 2017
Messages
112
>>>event>>On Load >>> hide id
 

Attachments

  • Annotation 2020-11-22 122736.jpg
    Annotation 2020-11-22 122736.jpg
    65.4 KB · Views: 102

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:51
Joined
May 7, 2009
Messages
19,169
can you set it's (the textbox) Visible property to No.
 

ypma

Registered User.
Local time
Today, 20:51
Joined
Apr 13, 2012
Messages
643
>>>event>>On Load >>> hide id
Have you tried the clicking the visible property of the field you wish to have as not visible , go to design mode of the report and click on the field , and under format you should see the visible property .

Best of Luck

ops i was too slow Arnelgp beat me to it.
Regard Ypma
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:51
Joined
May 7, 2009
Messages
19,169
make a Copy of this form and use the Copy on your report.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:51
Joined
May 7, 2009
Messages
19,169
if you are concern about making another copy of form will bloat your db.
it does not. in fact you can create as many form as you like.
using "single" form is better, but i'm afraid it won't be doable in Report.
 

SalmanZeiad

Member
Local time
Today, 22:51
Joined
Oct 30, 2017
Messages
112
if you are concern about making another copy of form will bloat your db.
it does not. in fact you can create as many form as you like.
using "single" form is better, but i'm afraid it won't be doable in Report.
thank you
 

Minty

AWF VIP
Local time
Today, 20:51
Joined
Jul 26, 2013
Messages
10,355
Form controls have a Display When property. Three settings Alway (Default), Print Only, Screen Only.

Set it to Screen only.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:51
Joined
Oct 29, 2018
Messages
21,358
Forms are meant for display, and reports are meant for printing. It's best to use the correct tool for the right job. Just my 2 cents...
 

Minty

AWF VIP
Local time
Today, 20:51
Joined
Jul 26, 2013
Messages
10,355
Forms are meant for display, and reports are meant for printing. It's best to use the correct tool for the right job. Just my 2 cents...
@theDBguy Absolutely, couldn't agree more.
Just being a Sunday couldn't be bothered to argue about it. :rolleyes:
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:51
Joined
Oct 29, 2018
Messages
21,358
@theDBguy Absolutely, couldn't agree more.
Just being a Sunday couldn't be bothered to argue about it. :rolleyes:
@Minty No offense intended. I wasn't trying to argue with anyone. Just voicing my humble opinion (2 cents worth). Cheers!
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 16:51
Joined
May 21, 2018
Messages
8,463
'To show the ID control if used in a subform of a form and hide it in the report

Code:
me.id.visible = (TypeOf me.Parent Is Access.Form)
 

Users who are viewing this thread

Top Bottom