Hidden data in field

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

Guest

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!!!!
 
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
 
Back
Top