numeric format using iif function.

From: "Frank" <fhsmith7@xxxxxxxxxxxxx>
Date: Tue, 19 Jul 2005 21:14:20 -0500

I have a text box with the following Control source IIF function. It returns
data such as: record 1500 of 2289; 1501 of 2289; etc.

I would like the numbers to have commas separate thousands. For example, I
would like the return to be 1,500 of 2,228; 1,501 of 2,228, etc. Any
assistance is most welcomed.

=IIf([CurrentRecord]>(Count(*)),'New Record',('Record ' & [CurrentRecord] &
' of ' & Count(*)))

.

Follow-Ups:
- Re: numeric format using iif function.
  - From: Frank
- Re: numeric format using iif function.
  - From: Frederick Wilson

Prev by Date: RE: Make a text box visible if a different text box has text in it
Next by Date: Re: Capturing SubForm Events
Previous by thread: Modifying the current record in code
Next by thread: Re: numeric format using iif function.
Index(es):
- Date
- Thread