TextBox or Label not showing in Report until mouse "click"

[Russell]

I have a report that is working fine when viewed alone, but want it to appear in a navigation pane.
When it viewed via Navigation pane the header textbox (and have tried using a label instead) - value set by VBA - do not appear until the mouse is clicked.
Textbox then appears correctly.

Initially had code grabbing the values dynamically (DLookup), but tried TempVars in case it was related to load order and accessing data.
(Again... report works fine when viewed directly)

Code for textbox value:



Me.txtFireDutyReportTitle = "Fire Duty List : " & TempVars!TempUserDistrictName & " District - " & TempVars!TempUserPlatoonName & " Platoon"

Either I'm missing something, or at least as a workaround with some code to "simulate" the mouseclick as part of the report load.

Thanks, Russell

[Micron]

Just so you don't confuse others, you mean you want your report to load in a navigation form, not navigation pane, yes? The nav pane is the pane on the left side that shows all the db objects. All I can think of is the cause for this when using forms - the textboxes had multiple lines/rows in it, such as
dog
cat
bird
That can do weird things with the data display. Maybe check yours for multiple lines with a few records. It might differ between records.

[Russell]

Just so you don't confuse others, you mean you want your report to load in a navigation form, not navigation pane, yes? The nav pane is the pane on the left side that shows all the db objects. All I can think of is the cause for this when using forms - the textboxes had multiple lines/rows in it, such as
dog
cat
bird
That can do weird things with the data display. Maybe check yours for multiple lines with a few records. It might differ between records.

FYI - Yes, loading into the Nav main field, below the tabs..... good news is just solved it!

SOLUTION
Defining the textbox value in the VBA worked fine viewing report directly - textbox only failed when loaded by and viewed with NavForm.

I transferred my code from the VBA Code Builder to the actual textbox - and report now loads correctly in the Navigation Window.
Copying the VBA line ="[insert code from original post]" into the actual textbox value did the trick.

Thanks for your help anyway.

[Micron]

Sound like it was an issue with the path for referencing a control on a nav form. For future reference:

Forms![main navigation form].[NavigationSubform].Form

frmNavigation is often the default name given to the navigation form by Access, IIRC. In the below example, frmOvertime is the subform control on the nav form, so to refer to a textbox named txtEmpID:

Forms!frmNavigation!frmMain.Form!frmOvertime.Form.txtEmpID

Should be the same for reports except you'd swap Form! with Report! I guess.