Re: numeric format using iif function.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Fredrick:

I tried your first option by placing it in the Control Source. It did not
work. I'm not sure how to create a Public Function or exactly where to put
it as I am relative new to VBA coding. Any assistance is appreciated in this
area.




"Frank" <fhsmith7@xxxxxxxxxxxxx> wrote in message
news:RqiDe.11398$xn.11102@xxxxxxxxxxxxxxxxxxxxxxxxx
>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(*)))
>


.

Relevant Pages

  • Re: Attempting to create a function that i can use in a query.
    ... I would like a wee bit of assistance in attempting to use this code ... Public Function NormSInvAs Double ... a standard select query yet when I try to run the query I get the ... It need to be a standard ...
    (microsoft.public.access.modulesdaovba)
  • Re: CalculatingDisplaying Time over 24 hrs
    ... When I put this in as my control source, ... one for the detail called txtTime and one for the Summary called txtTotalTime. ... However, since it does not add up correctly, I added this code as a Public Function. ... Dim intHours As Integer Dim intMinutes As Integer ...
    (comp.databases.ms-access)
  • RE: Sum Function Error
    ... I did think about Larry's assistance a little more too. ... entirely sure how to initiate it, but what he was describing was to make a ... if iserror([your equation using appropriate references]) then ... the other three functions that are available in the control source. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Global Variables
    ... Public Function GetAgentName() As String ... in the "Main" form I have a control that opens a report which also has ... a textbox with =GetAgentNameas control source. ...
    (microsoft.public.access.formscoding)
  • Re: Calculating Age
    ... because Ive used DOB and SDate. ... Placing the control source is easy:) LOL ... There is no Age in the list under where the DateDiff thing is when you look ... > The code would be placed in a module as a Public Function. ...
    (microsoft.public.access.gettingstarted)