Blank Fields

[Connie]

Not all of the fields in a record have data. I use my Access database to
show information on my webpage. When the field of a record is blank, how do
I close the blank space it leaves on my webpage?

 

[Stefan Hoffmann]

hi Connie,

Not all of the fields in a record have data. I use my Access database to
show information on my webpage. When the field of a record is blank, how do
I close the blank space it leaves on my webpage?

An Access solution:

Use a query to retrieve the data, e.g.

SELECT Nz([yourField], "<no data>") AS NzYourField
FROM yourTable

Otherwise it depends on the "how do you create your web page"... PHP,
Java, ASP.Net...


mfG
--> stefan <--