[AccessD] [EXTERNAL] Text in the Status Bar

[Paul Wolstenholme]

Shane,

Thanks for that.
My existing code only uses
SysCmd(acSysCmdSetStatus, " ")
so I will change that to
SysCmd(acSysCmdClearStatus)

It's good to know Microsoft is aware of a status bar truncation bug.  That
tells me I've done nothing wrong to cause that and I probably can't avoid
the issue.

It might be a while before I get back to this task.  There are many other
more important things to deal with right now so negotiating to remotely
borrow an Access 2016 machine hasn't happened yet.  I do offer users
mouseover text with the same message as the status bar - but they do have
to know to look for it.

Yes - there is a big difference between unexpectedly failing to see what I
thought I had coded and having an example that proves Access is broken.

Paul Wolstenholme


On Mon, 29 May 2023 at 17:46, Shane Groff via AccessD <
accessd at databaseadvisors.com> wrote:

> SysCmd(acSysCmdClearStatus) should be sufficient to restore the status bar
> behavior to showing control status text.
> If you have more details than 'seeing some unexpected results', ideally a
> database that demonstrates the problem that you can share, then we could
> investigate.
>
> We are aware of a bug with the status bar text being truncated
> inappropriately in some cases, but it has not been resolved yet.
>
> Shane
>
> -----Original Message-----
> From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com>
> On Behalf Of Paul Wolstenholme
> Sent: Thursday, May 25, 2023 8:20 PM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: [EXTERNAL] [AccessD] Text in the Status Bar
>
> [You don't often get email from paul.w at industrialcontrol.co.nz. Learn why
> this is important at https://aka.ms/LearnAboutSenderIdentification ]
>
> Hi,
>
> I have an Access 2010 application running on client computers with various
> Access versions.
> In some instances I use VBA to set, and then later to clear, a status bar
> message:
>
> ' Set a status bar message
> SysCmd(acSysCmdSetStatus, "A message goes here")
>
> ' Clear any status bar message
> SysCmd(acSysCmdSetStatus, " ")
>
> From that point I would like the status bar to show the content of the
> status bar text property of the current form's current control.
>
> I've been seeing some unexpected results on Access 2016 during a site
> visit where detailed testing wasn't practical (the licence was Office
> Professional 2016).  I don't have that version on my own computers.
> My research is showing some references to
>
> SysCmd(acSysCmdClearStatus)
>
> or
> SysCmd(acSysCmdSetStatus, " ")
> SysCmd(acSysCmdClearStatus)
>
> Does anyone know what command sequence can be relied upon to return the
> status bar to displaying the status bar text property on all Access
> versions (or at least >= 2010)?
>
> I've also seen Access 2016 showing a truncated version of the status bar
> text property.  Can anyone please tell me how that might come about?  There
> is no usage of the progress bar in the database so I hoping that isn't it.
>
> Paul Wolstenholme
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com/
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>