Listbox listcount

[SF]

Hi,

I have a form with a listbox [list4] and a textbox to show number of record
in the listbox. In the Control Source of textbox, I put the following:
=[List4].[ListCount].

The problem is when I turn Colum Head of the listbox on, the textbox result
always show one record extra.

Is there a way to correct this?

SF

 

[Gina Whipp]

SF,

Try =[List4].[ListCount]-1

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dirk Goldgar]

Hi,

I have a form with a listbox [list4] and a textbox to show number of
record
in the listbox. In the Control Source of textbox, I put the following:
=[List4].[ListCount].

The problem is when I turn Colum Head of the listbox on, the textbox
result
always show one record extra.

Is there a way to correct this?

Didn't you post this question a couple of days ago? I see two good
responses in that original thread.

 

[Gina Whipp]

Dirk,

Interesting, I don't see the question or the answeres posted and I'm using
Outlook Express. Perhaps they s/he is having the same problem?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi,

I have a form with a listbox [list4] and a textbox to show number of
record
in the listbox. In the Control Source of textbox, I put the following:
=[List4].[ListCount].

The problem is when I turn Colum Head of the listbox on, the textbox
result
always show one record extra.

Is there a way to correct this?

Didn't you post this question a couple of days ago? I see two good
responses in that original thread.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Dirk,

Interesting, I don't see the question or the answeres posted and I'm using
Outlook Express. Perhaps they s/he is having the same problem?

Probably. I see them in Windows Mail, though, and Google Groups has the
thread:
http://groups.google.com/group/microsoft.public.access/browse_frm/thread/872927b59d6265ca

 

[Gina Whipp]

Dirk,

Interesting... I have been putting off using Windows Mail because I don't
like the interface. Thanks for the link!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dirk Goldgar]

Dirk,

Interesting... I have been putting off using Windows Mail because I don't
like the interface. Thanks for the link!

Are you confusing Windows Mail with something else? Windows Mail is just
the equivalent of Outlook Express that runs on Vista. It's only slightly
different from OE. If you're thinking of the web-news interface that
Microsoft provides, I find it too clunky to use.

 

[Gina Whipp]

Nope, got my Viata machine in next room... It is not the same, I can't
customized the way I did Outlook Express OR should I say since I don't like
Vista I haven't sat there long enough to even get past the opening. And
let's not even go into the Microsoft Web Interface...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm