Re: DTPicker

From: Bob (anonymous_at_discussions.microsoft.com.invalid)
Date: 08/07/04

  • Next message: Ed: "Datagrid" 
    Date: Fri, 6 Aug 2004 19:54:20 -0700

    Hi Don:

    I was just wondering about the DTPicker. I thought that I could not, but I
    wanted to ask someone who knows more than I do.

    On the BestFit issue, for every cell of the column in the Flexgrid, I have
    to check to see how wide it is ,and then find the best format that fits.
    Unfortunately, I could not come up with a generic format to fit no matter
    the value of the cell. So, after playing a lot, I decided to stick to my
    own routine which I pasted it in one of the messages. The only change I had
    to make was that instead of using the TextWidth property of VB, I am using
    the API function. The API made the code about 3 times faster on my machine,
    which is great for large number of cells. I could not make it any faster
    than this. As you know, in excel if I fill all the columns with random
    number, and then go and make the width of the column larger, the new best
    fit values are displayed almost instantaneously. On my grid it takes about
    2 to 3 seconds for 65000 rows. I guess I can live with it.

    Thanks for asking and all your help.

    Bob

    "Don Hanfland" <fakemail@no.spam> wrote in message
    news:%23AlUc1$eEHA.248@TK2MSFTNGP12.phx.gbl...
    > Hi Bob,
    >
    > The text portion of the dtp is like a maskeditbox but is limited to only
    > date time types of formats, so you won't be able to have it blank in the
    > beginning at least not that I have been able to do.
    >
    > BTW; how did you make out on the Best Fit Format of Numbers post of yours?
    >
    > Impressed with all your learning!
    > Don Hanfland [MVP -VB]
    >
    >
    > "Bob" <anonymous@discussions.microsoft.com.invalid> wrote in message
    > news:uMBxRy2eEHA.1356@TK2MSFTNGP09.phx.gbl...
    > > Hello all:
    > >
    > > in VB 6.0, by default, if you use a DTpicker control, in its text box
    > > portion it is divided into 3 parts, one of the day, one for the month
    and
    > > one for the year. Is there a way, to make it a simple textbox, without
    > the
    > > "/", so that users can simply type? I know that if you type "/", the
    > > control ignore them, but for looks, when the control receives focus, I
    > want
    > > the text portion to be completely blank.
    > >
    > > I appreciate all your help.
    > >
    > > Bob
    > >
    > >
    >
    >

  • Next message: Ed: "Datagrid"

    Relevant Pages

    • Re: Cell dsplays the Formula, NOT the result
      ... Just like you always try to utilize the international date format Bob, ... I've been critisized for describing the keyboard shortcut to toggle Formula ... > Sounds like you have the cell formatted as text. ...
      (microsoft.public.excel)
    • Re: multipage columns
      ... >Hi Bob ... >language in the right cell. ... >If you don't want lines around the cells, use Format> ... >Jay Freedman ...
      (microsoft.public.word.pagelayout)
    • Re: Formatting Cell Using Formulae....advise please....
      ... I do understand what the Proper function does now, but it does not do for me ... What is the most commonly used way to format text in a spreadsheet for best ... > Hi Bob, ... >> On the first point, you would enter the PROPER formula in an adjacent cell, ...
      (microsoft.public.excel.misc)
    • Re: Pound Signs Instead Of Text
      ... There seems to be a quirk, where in a Text formatted cell of more then ... General format should work for the "in-between" character count. ... I know the text can fit because when I'm editing it, ...
      (microsoft.public.excel)
    • Re: 2 Conditiaonal Formatting
      ... "Bob" Thanx so much for replying, ... only show when its a value, say it returns $1000.00, but else when the shade ... >> some columns which was before like this CELL VALUE IS LESS THEN 0, FORMAT ...
      (microsoft.public.excel.misc)