Hidden data in field

M

Msandy

Does anyone know how to hide data in field but keep the record in the report. I have a report of 3 colums of dates, and I only want to display the dates from today and forward, but the record needs to remain in tact. I've tried to do an event. I've tried to run a macro and I've tried to type an expression in the criteria field, but what happens is it takes out the entire record if the dates are today and before. I only want the field blank. Can anyone help. I'm pulling out my hair!!!!
 
F

fredg

Does anyone know how to hide data in field but keep the record in the report. I have a report of 3 colums of dates, and I only want to display the dates from today and forward, but the record needs to remain in tact. I've tried to do an event. I've tried to run a macro and I've tried to type an expression in the criteria field, but what happens is it takes out the entire record if the dates are today and before. I only want the field blank. Can anyone help. I'm pulling out my hair!!!!
Click to expand...

Not sure I follow you, but if you just want to make the date field not
visible in the report, you can code the Detail Format event:
[DateField].Visible = [DateField]>=Date
 

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

Copy previous record into form field 0
Publisher is filling blank lines with data 2
VBA - exporting serial letters to single documents 0
Setting field value if a value exists in another table 3
VBA Scripts Word 2016 4
query to show where no data in a stated column 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Creating Labels Over 3-Up Image 2

Top