| Author |
Borders not appearing if field is null
|
|
|
| I have several fields that ive placed borders around.
However when a field is null the borders dont display.
How can I get the borders to appear even if the field is empty?
Thanks
| |
|
| Don,
I have not tried it and don't know if this will work. Have you tried
replacing the blank field with space?
PJ
"Don" <doncal@ntlworld.com> wrote in message
news:e9oPXEVXFHA.1468@tk2msftngp13.phx.gbl...
I have several fields that ive placed borders around.
However when a field is null the borders dont display.
How can I get the borders to appear even if the field is empty?
Thanks
| |
| Bob Holmes 2005-05-23, 4:00 pm |
| Hi Don,
Adding to PJ's suggestion: replace the database field with a formula
field. The formula field will look for 'Null' and replace it with an empty
string. This way there is always something there.
If Not IsNull({Table.MyField}) Then {Table.MyField} Else " "
--
Bob Holmes
"Don" <doncal@ntlworld.com> wrote in message
news:e9oPXEVXFHA.1468@tk2msftngp13.phx.gbl...
> I have several fields that ive placed borders around.
> However when a field is null the borders dont display.
>
> How can I get the borders to appear even if the field is empty?
>
> Thanks
>
>
|
|
|
|