Make invisible in datasheet

[SAC]

Access 2003

How do I make a row invisible in a datasheet form if it's date is less than
a year ago?

Thanks for your help.

 

[Jeff Boyce]

One way would be to not put it in there in the first case...

That is, if you base your form on a query, you can use the query to restrict
the records to only the ones less than a year old.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[SAC]

Wish I could, but I need them all for calculation purposes. Just don't want
to see older ones.

Any other ideas?

Thanks for you help

 

[Marc B.]

do u want to make it invisible in textbox on form or in listbox on form or
in the main table?

 

[VAndo]

Access 2003

How do I make a row invisible in a datasheet form if it's date is less
than a year ago?

Thanks for your help.

 

[John Spencer]

Basically you can't hide a row in datasheet or continuous form view. I guess
you could use conditional formatting to set the text to white if you have a
white background. You wouldn't see the data but would see a "blank" row for
every record.

Possibly you could find another way to get the calculation results so they are
not dependent on the rows that are displayed in datasheet view.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[SAC]

I need the entire row to be invisible in in a datasheet form.

Thanks.

 

[John Spencer]

In Datasheet view you see all the rows that are in the source. No other
option exists. You cannot hide a row if it is in the source, you have to
exclude the row.

I guess you could populate an Excel spreadsheet and then hide/show rows in the
spreadsheet, but Access does not have the ability to do so in Access.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[SAC]

Thanks John. I decided to restrict the rows in the data source and then a
dlookup for the rows prior to the date I'm using.

I appreciate your help.

Thanks.