Rounding up in Form view

REN DUTOIT

• 2022年09月21日 00:44

Hi, 

Please help, Using Bartender 2019 R6. Might seem like there's an easy solution but I cant find it anywhere.

Some of my database columns, which are only number fields gets a suffix of a decimal and 4xZeros.

But our actual data has only a number. I have narrowed it down to being an Excel .CSV issue as it might be embedded within the exported .CSV file. I can eliminate the decimal and zeros in the design template stage with simple VB script but when in Forms I cant seem to find the option to add some VB script to trim. Or even just some simple form options for each column maybe?

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2022年09月21日 10:36

  I am not sure you can strip off the zeroes in the Record Picker box itself. Also any formatting of data in the label is only carried out after the record has been selected.

  Rather than use VB, if you use the Transforms>Truncation>Discard Characters of Right = 5 for these fields then you could add a PIcture>Preview of Template your Data Entry Form so the users could see the label with the characters removed at print time, such as

  

  0

请先登录再写评论。