Mixing variable types (1 Viewer)

I was wondering if anyone can tell me why this doesn't work?

Dim MooringLines As String
Dim MooringLinesPrice As Double
MooringLines = DLookup("TotalComponent", "ComponentT", "[TotalComponent] = '" & Me.P_MooringLinesCmb & "'")
MooringLinesPrice = DLookup("EuroPerMetre", "ComponentT", "[TotalComponent] = '" & Me.P_MooringLinesCmb & "'")
Me.P_MooringLinesTxt = (MooringLines + " - €" + (MooringLinesPrice * Me.P_LengthMLTxt.Value))

In the first variable I'm trying to get a string and combine it with a double in the second. Is it that I can't mix a string and a double in the one variable and if so how do I convert the double to a string?

What does "doesn't work" mean? For starters, try using & instead of + to concatenate. Mixing data types in the last line shouldn't matter.

Sorry the question was a bit vague bit changing + to & worked. Thank you

No problem.

The & is the standard VBA concatenation character. The + is an alternate but will not work in every situation and has different properties when it does work.

The + is an arithmetic operator first and foremost so if the two operands are numeric, they will be added rather than concatenated.

The other difference occurs when one of the operands is null. Most operations result in null if either operand is null and that is true when the + is used so a + null results in null. However, a & null results in a. You can use this to your advantage when concatenating strings where some operands are optional and you want to eliminate the separators when the operand is null.