Gray bar along bottom of form header

[cowboy]

I have a gray bar along the bottom of my form header as shown in the first image:


Here is an image of the form in design view if that helps. It is a split form:




I have done some googling and searching of this forum but have not been able to find the answer.
Thank you for any help you can provide.
-Dan

[pbaldy]

I have a vague memory of a theme adding some sort of two-tone look like that. Is there a theme applied? I can't recall offhand where that would be specified, but if you can attach the db I can play around and find it.

[cowboy]

I stripped some of the data down and just left in an example or 2 so it would still run. Only background I might mention is this was originally created as a .mdb and was converted to .accdb. I am not sure if that could have caused any problems. Also still working on some of the buttons so not everything is functional.

Review Tracking_Beta-v19-01-31 - Copy.zip

Thanks pbaldy

-Dan

[isladogs]

PMFBI
The problem was in the detail section. I switched off alternate back colour and changed default view to single form. All now seems OK to me

[cowboy]

changed default view to single form. All now seems OK to me

This does seem to get rid of the bar, but then the view only shows one record and the split form which I have it set to show all the records the query pulls.

[June7]

Go back to Split form and set the ScrollBars property to Vertical Only. The grey bar will go away.

[pbaldy]

Go back to Split form and set the ScrollBars property to Vertical Only. The grey bar will go away.

Nice, I didn't think of that. Interesting that it's at the top, but I suppose that's a split form thing, and I don't use them.

[June7]

Each section has its own scroll bars and that property is only for the single record view section, whether top or bottom.

[cowboy]

Go back to Split form and set the ScrollBars property to Vertical Only. The grey bar will go away.

Nice work June, you win again.

Now that gray bar was hiding the fact that the record I have selected in the detail sheet is showing in the header. I forgot about that part of the split view. I will need to figure out how to hide that. I am basically trying to get something where it gives the datasheet type view which has all the sorting and filtering capabilities while also allowing a header for navigation buttons and other tasks. This is working well enough for me, although not sure if it is the best approach.

Thanks everyone for the help.
-Dan

[isladogs]

Sorry about losing the split form earlier - was obviously having a senior moment.

Split forms are notoriously difficult to modify successfully.
For that reason you may find it useful to look at the emulated split form in this article http://www.mendipdatasystems.co.uk/e...orm/4594398119
Its the latest version in a project to overcome some of the issues with split forms whilst keeping the main functionality.

[June7]

Example of a 'search' form http://allenbrowne.com/ser-62.html.

I use unbound main form with a bound subform because I don't like the vertical scrollbar on a form in Continuous view.

I have only used split form for a very simple db with minimal code. Otherwise, I avoid it.