Removing a - from £-0.40 figure

[Moonshine]

As the title really

This is the code:

ElseIf .Fields![Transport] < 0 Then
MsgBox "We Currently Owe The Client £" & Format(.Fields![Transport], "0.00") & " For Transport"


The message box it produces says We Currently Owe The Client £-0.40

I want to remove the leading - from it, any ideas how? Im sure it involves InStr, Mid or Left somehow, but have no clue on the wording!

 

[Mile-O]

Use the Abs() function.

 

[Moonshine]

Thanks for that Mile, works of a fashion...

It now reposonds with, We Currently Owe The Client £0.4

Misses the last 0

 

[Moonshine]

Sorted it!

Format(Abs(.Fields![Transport]), "0.00")


Changed the Abs function round, so its included in the format.