% symbol deleting List Box content

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a list box which presents different content depending upon users
choices elsewhere on the form.

One option is to present amounts as percentages. This works perfectly on
most PC's. On a handfull (3 out of 55) the list box is blank if I include the
'%' symbol but fine if I leave it out. Any ideas?

The simplified coding to achieve this is:

Me.lboAlloc.RowSource = "SELECT fldFundSector, (Format(fldFundAmount,
'#.00%')) AS Expr1 FROM ......etc....."
Me.lboAlloc.Requery

I've tried (Format(fldFundAmount, '#.00') & '%') AS Expr1 to no avail.

Any ideas?

Thanks.

BW
 
Just to clarify as the 'subject' description I provided might confuse...

The underlying data that feeds to list box is not deleted, it just isn't
displayed if the '%' symbol is present in the format string (but only on a
few PC's).

BW
 
hi,
Me.lboAlloc.RowSource = "SELECT fldFundSector, (Format(fldFundAmount,
'#.00%')) AS Expr1 FROM ......etc....."
I've tried (Format(fldFundAmount, '#.00') & '%') AS Expr1 to no avail.
Click to expand...
Format(fldFundAmount, '#.00\%')) won't work either?


mfG
--> stefan <--
 
Back
Top