Record number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jennifer-Ashley - 28 Apr 2005 15:38 GMT

Hi guys,

Does any of you know how to show the current record number and record count
in a form, other than using the standard navigation buttons at the bottom of
the screen?

Thanx,
Jenn

Reply to this Message

Van T. Dinh - 28 Apr 2005 16:03 GMT

Create a (calculated) TextBox on your Form with ControlSource:

= [CurrentRecord] & " of " & [Recordset].[RecordCount]

(tested in A2K2).

Signature

HTH
Van T. Dinh
MVP (Access)

> Hi guys,
>
[quoted text clipped - 4 lines]
> Thanx,
> Jenn

Reply to this Message

Jennifer-Ashley - 28 Apr 2005 16:18 GMT

> Create a (calculated) TextBox on your Form with ControlSource:
>
> = [CurrentRecord] & " of " & [Recordset].[RecordCount]

Hi, thanks for responding. When I apply the above code in the TextBox and
run the form, the TextBox shows #Name?. Obviously, I am doing something wrong
here.

Thanks,
Jenn

Reply to this Message

Van T. Dinh - 28 Apr 2005 16:37 GMT

I tested it A2K2 and it worked fine on my laptop.

However, IIRC, there may be timing issue with this if you use a slow
computer or the Form's Recordset is big.

Leave the TextBox unbound and use the Form_Current Event to set the value of
the TextBox. Something like:

Me.MyTextBox = Me.CurrentRecord & " of " & Me.Recordset.RecordCount

Signature

HTH
Van T. Dinh
MVP (Access)

> > Create a (calculated) TextBox on your Form with ControlSource:
> >
[quoted text clipped - 6 lines]
> Thanks,
> Jenn

Reply to this Message

Jennifer-Ashley - 28 Apr 2005 19:22 GMT

> Leave the TextBox unbound and use the Form_Current Event to set the value of
> the TextBox. Something like:
>
> Me.MyTextBox = Me.CurrentRecord & " of " & Me.Recordset.RecordCount

Wow thanks, that worked! Nonetheless, I recently bought this computer, it is
very fast ans has more than 1 mB of internal memory. Anyways, it works.

Bye,
Jenn

Reply to this Message