displaying data that doesn't have null value

[Pete Dumont]

IS THERE A WAY TO HAVE ASDB DISPLAY INFORMATION IN A MS ACCESS TABLE THAT DOES NOT CONTAIN A NULL VALUE BUT SKIP THE ONES THAT DO? WHAT I MEAN IS IF I HAVE A TABLE WITH 5 COLUMNS,ONE RECORD IN THE TABLE HAS INFORMATION IN THREE OF THE COLUMNS, AND ANOTHER HAS INFORMATION IN 2 OF THE COLUMNS, IS THERE A WAY IN THE PRO VERSION TO ONLY SHOW THE USER THE COLUMNS THAT HAVE INFORMATION IN THEM (SKIPPING THE EMPTY FIELDS) WHEN IT DISPLAYS THE FORM?

[Mark]

Pete,
There is no way using the ASP-db "Form" to prevent empty fields from
getting displayed. HOWEVER, if you display the data yourself (using the
technique in Example A14a), you can suppress empty fields from getting
displayed. You actually will have complete control over the format and
the contents of the display.

http://www.aspdb.com/examples/aspdbexa14a.asp

Mark.