This doesn't read like an SQL issue, more a GUI issue.

I may be wrong but it sounds like what she wants is that if the field is NULL then do not display the field on the form

Changing the number of columns returned by a query would require Dynamic SQL which should be avoided whenever possible for a number of reasons

(SQL injection attacks and query plan cacheing to name two)