Prev: Merge image file in Access 2007 attachment field into Word document
Next: Create a seperate PDF Report for each company
From: Marshall Barton on 14 Nov 2009 15:57
I made a mistake in my suggested Format property setting. I
meant to say:

0;"";""
--
Marsh
MVP [MS Access]


Linkerbink wrote:
>Well, thanks for all the replies. Unfortunately, I'm a newbie at Access and
>your responses are beyond my comprehension! I'll see what I can figure out.
>
>"Marshall Barton" wrote:
>
>> Linkerbink wrote:
>>
>> >In a report, I want a particular control to be visible only when the value is
>> >more than zero. I used the conditional formatting for the control and set it
>> >to the expression:
>> >IIf([Reg]>0,[Reg],"") but it doesn't work. I tried doing it without the IIf
>> >but that doesn't work either.
>>
>> Conditional Formatting does not deal with visibility.
>>
>> Your expression would be appropriate as a text box's
>> ControlSource expression as long as the text box is named
>> something other than [Reg]
>>
>> But since this is more a formatting issue than a
>> calculation, it would be better to use a custom format
>> something like:
>> 0;;;""
>> See Format Property in VBA Help for details on creating
>> custom formats.

From: Lloyd on 15 Nov 2009 06:21
You might try setting the can shrink value to 'yes' in the control's property
sheet-format tab,
--
Lloyd


"Linkerbink" wrote:

>
> Well, thanks for all the replies. Unfortunately, I'm a newbie at Access and
> your responses are beyond my comprehension! I'll see what I can figure out.
>
> "Marshall Barton" wrote:
>
> > Linkerbink wrote:
> >
> > >In a report, I want a particular control to be visible only when the value is
> > >more than zero. I used the conditional formatting for the control and set it
> > >to the expression:
> > >IIf([Reg]>0,[Reg],"") but it doesn't work. I tried doing it without the IIf
> > >but that doesn't work either.
> >
> > Conditional Formatting does not deal with visibility.
> >
> > Your expression would be appropriate as a text box's
> > ControlSource expression as long as the text box is named
> > something other than [Reg]
> >
> > But since this is more a formatting issue than a
> > calculation, it would be better to use a custom format
> > something like:
> > 0;;;""
> > See Format Property in VBA Help for details on creating
> > custom formats.
> >
> > --
> > Marsh
> > MVP [MS Access]
> > .
> >
First  |  Prev  | 
Pages: 1 2
Prev: Merge image file in Access 2007 attachment field into Word document
Next: Create a seperate PDF Report for each company