Home > Archive > Visual Basic Crystal Reports > April 2005 > blank fields not visibles
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
blank fields not visibles
|
|
| garsio 2005-04-20, 4:39 pm |
| i have formated some fields with all borders in order to show like a box, but if there is null data in the db field the box is not visible, how can i prevent this.
Also if i dimension de height of the box for three or four lines, cr auto shrink to the numbers of lines in the text field to, for example one.
Thanks in advance.
Garsio | |
| Bob Holmes 2005-04-21, 4:01 pm |
| Hi Garsio,
For the first problem, you could use a formula field instead of the
database field. The formula would look for the Null value and return a
single space. This way the formula field is not Null and will display the
borders:
If IsNull({Table.MyField}) Then " " Else {Table.MyField}
--
Bob Holmes
"garsio" <garsio.1ntfpq@mail.codecomments.com> wrote in message
news:garsio.1ntfpq@mail.codecomments.com...
>
> i have formated some fields with all borders in order to show like a
> box, but if there is null data in the db field the box is not visible,
> how can i prevent this.
> Also if i dimension de height of the box for three or four lines, cr
> auto shrink to the numbers of lines in the text field to, for example
> one.
> Thanks in advance.
> Garsio
>
>
>
> --
> garsio
> ------------------------------------------------------------------------
> Posted via http://www.codecomments.com
> ------------------------------------------------------------------------
>
|
|
|
|
|