don't put Format in the ControlSource* -- it converts to a string. Instead, set the Format property for the control (right-click in design view, choose Properties)
* RecordSource is the source of records for a form or report
warm regards,
Crystal
* have an awesome day :)
--- On Sun, 8/28/11, djsdaddy531 wrote:
> Great Day, I have a subform that adds
> auto parts to a particular repair. I placed a text box
> (txtPartsSubTotal) in the footer of the subform. the record
> source for txtPartsSubTotal is
>
> =Format(Sum([PartTotal]),"$#,###.00")
>
> PartTotal is a field in the table that permits the user to
> enter the price of a particular part.
>
> Then I add sales tax with the following line in the record
> source:
>
> =Format(([txtPartsSubTotal]*0.06),"$#,###.00")
>
> After this I want the form to add the two fields to give
> the grand total in a field named txtPartsTotalCost, and the
> Record source is
>
> =Format(([txtPartsSubTotal]+[txtPartsSalesTax]),"$#,###.00")
>
> this code treats txtPartsSubTotal and txtPartsSalesTax like
> a string and simply connects the two numbers into a string.
> I have formatted both text boxes to Currency.
>
> thanks in advance
>
>
Tidak ada komentar:
Posting Komentar