Displaying Record Numbers with out Navigation controls....

  • Thread starter Thread starter Allen Jaffee
  • Start date Start date
A

Allen Jaffee

Hello All:

Perhaps an elementary question. I have some gifs for record
navigation that have replaced the arrows @ the bottom of the
form. How can I display just the amount of records with out
having the default navigation controls (since I have 'made'
my own) ?

TIA
 
Hello Allen,

You can create a Label control on your form (in the example below, it is
named lblNavigate) and then in the On Current event of your form, insert the
following code:

If Me.NewRecord Then
Me!lblNavigate.Caption = "New Record"
Else
With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me!lblNavigate.Caption = "Record " & Me.CurrentRecord & " of " &
..RecordCount
End With
End If

hth,
 
Cheryl,

Thanks, but here's a rather silly reply, the 'Label
control', is that like a text box with the control source as
'lblNavigate'?

TIA
 
Allen,

A Label Control is a separate control from a Textbox; if you will look at
the toolbar in design view of a form, it is the first icon to the right of
the "magic wand" (immediately to the left of the text box control). Label
controls exist primarily to store text or other descriptive material that is
not bound to data in a table or a query, so they have no Control Source and
they also have no Events. Typically, labels do not change as you move from
record to record unless there is VBA programming in place that forces a
change in a label's caption property.

hth,
 
Cheryl,

Took a few moments (top floor of molasses). Thrown off by
the extra <cr> before .RecordCount @ the end. Too fast w/my
cut-n-paste I guess.

Thanks alot !!!
 
Cheryl,

Perhaps the jury is still out. For some reason, unless I
click on one of my navigations (next rec) it does not
display how many records there are. I thought it worked.
I'll have to trace my steps......
 
Back
Top