Want to Hide blank fields in a single record

  • Thread starter Thread starter Patti
  • Start date Start date
P

Patti

Can any one help?? I have a table that will only have 1 record in it
at any given time (all records are exported to another table)and I
want to hide the blank fields in the final report. The same fields
will not be blank (empty) every time. Any idea how to do this???

Thanks
Patti
 
Patti said:
Can any one help?? I have a table that will only have 1 record in it
at any given time (all records are exported to another table)and I
want to hide the blank fields in the final report. The same fields
will not be blank (empty) every time. Any idea how to do this???
Click to expand...

Set the CanShrink property in the Report for both the textbox and the
section to "Yes" If there is nothing else but the textbox and its associated
label on the row of data, it will dissappear. If that won't work, you can
always set the visible property to False in the Detail Section's OnFormat
event:

If Len(Me.txtBox & vbNullString) = 0 Then Me.txtBox.Visible = False
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I've used something along this line in a similar situation:

A query based on your table

FieldOne - FieldTwo - FieldThree ------ Expr: IIf([FieldOne] is not null,
[FieldOne]) -- Expr2: IIf([FieldTwo] is not null, [FieldTwo])

Your report runs from the expressions and there is only something in the
expression if the field "is not null"

jim
 
You all are GREAT
Thank you
Patti



Jim Harrison said:
I've used something along this line in a similar situation:

A query based on your table

FieldOne - FieldTwo - FieldThree ------ Expr: IIf([FieldOne] is not null,
[FieldOne]) -- Expr2: IIf([FieldTwo] is not null, [FieldTwo])

Your report runs from the expressions and there is only something in the
expression if the field "is not null"

jim


Patti said:
Can any one help?? I have a table that will only have 1 record in it
at any given time (all records are exported to another table)and I
want to hide the blank fields in the final report. The same fields
will not be blank (empty) every time. Any idea how to do this???

Thanks
Patti
Click to expand...
Click to expand...
 
Can any one help?? I have a table that will only have 1 record in it
at any given time (all records are exported to another table)and I
want to hide the blank fields in the final report. The same fields
will not be blank (empty) every time. Any idea how to do this???

Thanks
Patti
Click to expand...

I tried the query as suggested but it is still showing the blank
records. On further thought this will have to be done in a query. If
anyone has any suggestions I could really use the help.

Thanks again
Patti
 
Back
Top