Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to controll date blank (2000 sr-1)

    DT NASCIAT is filed of table with property in attaced image...
    I have make the condion above but if really existis a date 01/01/1910 (is the date of byrthday)
    Iwant trapping to make blank the label="" if in this field the value is really blank, but i am sure not elegant...

    TEST_DATA = RSD1.Fields("DT NASCITA")
    If TEST_DATA = "01/01/1910" Then
    'If RSD1.Fields("DT NASCITA") = Null Then
    labelRate.Caption = ""
    else
    ...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to controll date blank (2000 sr-1)

    If the caption of the label is either blank or a fixed text, you might consider setting the caption in design mode, and hiding the label if necessary by setting its Visible property. And I would use the DateSerial function in the comparison:

    labelRate.Visible = Not (TEST_DATA = DateSerial(1910, 1, 1))

    This won't work if the caption of the label is variable.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to controll date blank (2000 sr-1)

    ok... test it tomorrow in my office...
    Tkls for all.
    Sal.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •