I have a report put together and I'm trying to change on of the fields to currency in the properties. Usually there's dropdown with options. This time there's no dropdown and it's blank. I've tried just typing in currency but that doesn't work. I used the Format formula in my query and it works, but some numbers are below $1,000 and other aren't. It looks somewhat strange when $930 looks like $0,930. I have it formatted to read $0,000. I like to keep the comma in there for numbers over 999. Any ideas why the format property might be blank? Thanks.