I'm trying to set the margins on textboxes so they align correctly. See attached screenshots.
The differences in the data is [UnitPrice] and [Extension] fields are currency fields in the database.
[UnitPriceEx] and [ExtPriceEx] are converted from a text field. See below fields.
I displayed them as both bound and unbound to make sure that was not causing the discrepancy.
Why does the underlying data make a difference on margins, even with the text being converted to currency?
Is there something else I'm missing?
Code:
UnitPriceEx: Format(Trim(Mid(Nz([PODetail]![Descrip3],""),InStr(Nz([PODetail]![Descrip3],""),"[unit_price: ")+13,(InStr(Nz([PODetail]![Descrip3],""),"[ext_price: ")-2)-(InStr(Nz([PODetail]![Descrip3],""),"[unit_price: ")+13))),"Currency")
ExtPriceEx: Format(Mid(Nz([PODetail]![Descrip3],""),InStr(Nz([PODetail]![Descrip3],""),"[ext_price: ")+12,InStr(InStr(Nz([PODetail]![Descrip3],""),"[ext_price: "),Nz([PODetail]![Descrip3],""),"]")-(InStr(Nz([PODetail]![Descrip3],""),"[ext_price: ")+12)),"Currency")
Thanks!