Format concatenated field with numbers

[LonghronJ]

Hello,



I have a text box that I'd like to show two fields concatenated together. I basically want the number to be shown as Standard without decimals. For an example, "Main Floor: 3,425 SF". The expression I currently have is

 "Main Floor: " & Format([Field1],"0,000") & " SF")

. I noticed that when the actual field is over 1000, the field displays exactly what I wanted. However, when the field is less than 1000, it displays funny. For an example, "Main Floor: 0,336 SF". I don't want the comma before 336. I can break the text box to two separate boxes to accomplish what I needed, but for the benefit of learning, How do I achieve displaying two concatenated fields with the format I want?

[jwhite]

I think you want # instead of 0 within the quotes: format([Field1],"#,###") & " SF"

[LonghronJ]

That seems to work perfectly. Thank You.