3 questions about Ms access

[ngaisteve1]

I got 3 question about Ms Access. Firstly, is how do I get rid of the
empty space (refer to attachment - address field)? And secondly is Is
it possible not to display those line which there is no data. Eg, in my
attachment is email and url. And lastly, if listing is yes, can I put
an * just next the company name?

 

[ngaisteve1]

forgotten the attachment.


+----------------------------------------------------------------+
| Attachment filename: ms_access.jpg |
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=133853|
+----------------------------------------------------------------+

 

[Larry Linson]

forgotten the attachment.

Good. You are not supposed to attach files except in newsgroups that have
"binaries" in the name, or unless the charter of the newsgroup specifically
permits it.

For other good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

Empty or null Controls can be made to shrink away (vertically only) by
setting their (surprise?) "CanShrink" property -- that's in the Format tab
of the Control's Property sheet. That's the answer to your first two
questions. Caveat: the Control will not shrink if there is another Control
alongside that isn't also shrinking.

What is "listing" that you want to check for "yes"? Clarify, and I'm sure
someone will be able to answer your question.

The questions most likely to get accurate and prompt answers are (1)
summarized in the Subject line (and may better be one question per post)
(2) precise and concise, explaining the details but very brief. For other
good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP