Move status bar to top of form

[fat_ankles]

I created a split form and the status bar is at the bottom. The form has a search box for calling up records, and some records have attachments. The status bar at the bottom shows the number of records resulting in the search. Example - Record 201 has no attachments so the status bar shows Record 1 of 1. Record 205 has 5 attachments (each attachment is a record) and the status bar shows 1 of 5. Bottom line is I just want to move the "status bar" to the top of the form instead of its current location at the bottom. Any assistance would be appreciated. Thanks in advance.

[June7]

Don't know of any way to accomplish that, other than 'build your own'. Could probably emulate with textboxes and VBA code. An expression in textbox can show the total records: Count(*)

[Missinglinq]

I'm sure that June7 is right...you'll need to 'roll your own' using a Textbox with the ControlSource of something like

= "Record " & CurrentRecord & " Of " & RecordsetClone.RecordCount & " Records"

Linq ;0)>

[June7]

Nice - I had forgotten CurrentRecord property, but not getting RecordsetClone to work in textbox expression. This does:

="Record " & [CurrentRecord] & " of " & Count(*) & " Records"

Put textbox in form Header or Detail section.

[Missinglinq]

Sorry I always use it in the Form_Current event, where it works just fine!

I've added yours to my archives, for use in the ControlSource.

Linq ;0)>

[Micron]

what about the activex status bar control 6.0?

[Missinglinq]

what about the activex status bar control 6.0?

Not familiar with that one, but most experienced developers only use ActiveX Controls as a last resort! The problem is that the version of the ActiveX Control needed is different for each version of Access, which makes it a pain when you're working in a multi-version environment, as well as a pain when porting a database up to a new version of Access.

Linq ;0)>