Continuous Form

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a continuous form that shows 2 fields one showing
per Case and per percent of cost represented by a 1 or a 2
in the field then I have an amount field. I want to know
if it is possible to have the amount show as a percent on
the per percent of cost or the amount only showing the
decimal when its per case. All the code I have tried has
chagned all the amount fields to percent or to decimal i'm
not able to single out each record.

Thx..
Mike
 
-----Original Message-----
I have a continuous form that shows 2 fields one showing
per Case and per percent of cost represented by a 1 or a 2
in the field then I have an amount field. I want to know
if it is possible to have the amount show as a percent on
the per percent of cost or the amount only showing the
decimal when its per case. All the code I have tried has
chagned all the amount fields to percent or to decimal i'm
not able to single out each record.

Thx..
Mike

.
Please post some of the code you have tried.
Click to expand...
 
Code is basically the same in different ways:
If Me.drayagetypeid.Value = 2 Then
Me.drayageamount1.Format = "Percent"
Else
Me.drayageamount1.Format = "General Number"

End If

I have also tried to make two fields one visible with the
percent format and the other with the General but like
allways the first record changes all the records to the
same as the first.

Thx.
 
Back
Top