I am having an extremely difficult time doing a simple task. I need to create a text box that contains both text and a decimal from my database. I want to add formatting to the decimal to remove all trailing zeros (not round, I want the full number displayed just not trailing zeros). Below is my current textbox value and the result;
='Acreage: '+ Fields.AssignmentAcres
Acreage: 640.000000000000000000
I've tried every iteration I can think of with the format function to no avail. Below is what I assume the textbox should look like but I keep receiving errors.
='Acreage: '+Format(Fields.AssignmentAcres, '####################.######################')
I've tried with single quotes, double quotes, no quotes, I even tried the formatting '0000.0000....'. No matter what I keep receiving errors. Please keep in mind that I am not a developer, I do not know coding very well. I've seen several answers googling this that requires quite a bit of code and I have no idea where to even put that code. I am using the "Edit Expression" dialog box to enter my field values. Thanks
='Acreage: '+ Fields.AssignmentAcres
Acreage: 640.000000000000000000
I've tried every iteration I can think of with the format function to no avail. Below is what I assume the textbox should look like but I keep receiving errors.
='Acreage: '+Format(Fields.AssignmentAcres, '####################.######################')
I've tried with single quotes, double quotes, no quotes, I even tried the formatting '0000.0000....'. No matter what I keep receiving errors. Please keep in mind that I am not a developer, I do not know coding very well. I've seen several answers googling this that requires quite a bit of code and I have no idea where to even put that code. I am using the "Edit Expression" dialog box to enter my field values. Thanks