Re: Short Date

Tech-Archive recommends: Fix windows errors by optimizing your registry

You must make sure that the time is already set to 0 (or midnight) on the
backend table. In your case, your are setting it to 0 on the control after
the control has already begun the edition of the value; I don't think it has
the same effect.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"Vadim Rapp" <nospam@xxxxxxxxxxxxx> wrote in message
news:O3PieXHDKHA.4316@xxxxxxxxxxxxxxxxxxxxxxx
On a form, I have textbox bound to datetime column on the server. The
column may contain time as well, but I don't want to see it on the form. I
specify Format="Short Date". Then it shows up without the time, but as
soon as it gets focus, the time shows up. Is there a way to avoid it? I've
put

Private Sub D_GotFocus()
If CLng(D) <> D Then D = CDate(Split(CStr(D))(0))
End Sub

but maybe there's some trick to achieve the same without coding?
specifying decimal places=0 as well as specifying input mask don't have
any effect.

Vadim Rapp



.

Relevant Pages

  • Unbound control does not refresh when the forms recordset is empty
    ... I have a bound continuous form and a bunch of unbound controls in the ... ' after specifying the desired filtering criterion ... ' Get date specified in unbound text control: ... Private Sub cmdSetMinDateToNow() ...
    (microsoft.public.access.formscoding)
  • Re: Service hangs when accessing ActiveX control
    ... correctly in an STA on the main thread but you are later calling into this ... your OnStart method and then create the form and control in the ThreadStart ... Application.Runto start the message pump. ... > Not specifying any attribute or specifying it as STA results in the same ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Service hangs when accessing ActiveX control
    ... >> in an MTA by default, if this is not what you want, you have to create ... >> own STA thread. ... > Not specifying any attribute or specifying it as STA results in the same ... > I wouldn't make it a control, but a simple class that exposes the same ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Devpower FTP Control Help
    ... I'd hazard a guess at your not specifying the path to the remote file...... ... > I have not used the FTP control with VB before and trying to get ... I can either pull all the text files "*.txt" or simple specify ...
    (microsoft.public.vb.general.discussion)
  • Re: how do i enable security for this to run?
    ... When something requires FullTrust to run (for ... >Clearly stated in the help documentation, "Specifying Which Runtime Version ... the control ends up running under v1.1.4322 ... >of the runtime, so the security setting changes that I ...
    (microsoft.public.dotnet.security)