Prev: Subform with 2 or more link criteria
Next: Add new record through Form view
From: Anatoly Kurilin on 26 Dec 2009 11:57
Hi, the Format (MiTime, "Short Time") command works fine in code and returns
the string "09:35" when the time is 9:35 AM. But then used in forms or in
queries it returns "9:35". Is there any way to make it return exactrly the
same string as in code "09:35"?

Is it possible to find out when the processs of filtering of sorting
finished in a form?

Thanks in advance,
AK


From: Arvin Meyer [MVP] on 26 Dec 2009 14:57
Try this:

Format([MiTime], "hh:nn AM/PM")
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" <akurilin(a)msn.com> wrote in message
news:%23EPPwwkhKHA.5568(a)TK2MSFTNGP02.phx.gbl...
> Hi, the Format (MiTime, "Short Time") command works fine in code and
> returns the string "09:35" when the time is 9:35 AM. But then used in
> forms or in queries it returns "9:35". Is there any way to make it return
> exactrly the same string as in code "09:35"?
>
> Is it possible to find out when the processs of filtering of sorting
> finished in a form?
>
> Thanks in advance,
> AK
>
>


From: BruceM via AccessMonster.com on 28 Dec 2009 10:01
Regarding the second question, it is when you see the filtered or sorted
recordset, unless I miss the drift. Did a specific situation prompt the
question?

Anatoly Kurilin wrote:
>Hi, the Format (MiTime, "Short Time") command works fine in code and returns
>the string "09:35" when the time is 9:35 AM. But then used in forms or in
>queries it returns "9:35". Is there any way to make it return exactrly the
>same string as in code "09:35"?
>
>Is it possible to find out when the processs of filtering of sorting
>finished in a form?
>
>Thanks in advance,
>AK

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200912/1

 | 
Pages: 1
Prev: Subform with 2 or more link criteria
Next: Add new record through Form view