Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2002
    Location
    Tampa FL
    Posts
    3

    Unhappy Unanswered: Need report to omit null textfields

    Hopefully I can explain this without getting into too much detail. Here is the design and grouping levels on my report:

    CorpID
    FacilityID
    PatientID - (Patient Name)
    FormID - (Form Name) ImportDate ExportDate ...

    Each patient can have more than one form, however the main problem is each form requires it's own table. So I end up with a lot of blank space because I have a seperate text field for every patients form.

    Ex. PatientID - Patient Name
    Form1 Import Date ExportDate ...

    Form3 Import Date ExportDate ...

    and so on...Is there a way to specify to omit (or program in VB) the null text fields in Form2 and bring Form3 up to make formatting cleaner?

  2. #2
    Join Date
    Aug 2004
    Posts
    40
    Are you creating this report from a query or table(s)?

    If it's a query add "Is Not Null" to the criteria of the field you don't want.

    If it's from tables then create a query for the report and do the above.

  3. #3
    Join Date
    Nov 2002
    Location
    Tampa FL
    Posts
    3

    woops

    Sorry I did not explain correctly, the forms are actually text BOXES which are in descending order order from 1 to 11. The actual text appears blank if it tis a null value but leaves a space causing a lot of unwanted whitespace.

  4. #4
    Join Date
    Aug 2004
    Posts
    40
    So do you want to not show the text boxes if they're null?

    if so the use something like on open form event

    if isnull(textbox1) me!textbox1.visible = false

    or

    propably a better option would be to concatenate all of your fields into one textbox e.g.

    tmptextbox = textbox1 & vbcrlf & textbox2 ... etc

    then create a textbox on your report and set the properties to allow it to shrink and grow.

    Howard

  5. #5
    Join Date
    Nov 2002
    Location
    Tampa FL
    Posts
    3

    Thumbs up

    Thanks a lot! not sure why I didn't think of that. I guess I had a case of tunnel vision there.

  6. #6
    Join Date
    Aug 2004
    Posts
    40
    Yeah, sometimes I can't see the grass for the trees either

    Cheers

Posting Permissions

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