Hi,
Can someone help me here.
My report layout is DB field with some textboxes. The report needs to be exported to Excel format. In excel where the blank textboxes are, the user must be able to key in a 10 decimal value data. So I inserted a textbox in the detail section next to the Name field. I am able to export to excel. But when I key in numbers, I am able to key in upto 9-decimal places, the moment I key the 10 decimal and I see only 9 appearing. Not sure why.
On a separate note, I excel, in a new sheet when I tried to key in 10 decimal value I have no issues. So no problem with excel, probably with export of blank textbox.
Please someone help me understand how I could use a blank field in the report to populate a 10-decimal data after export.
Can someone help me here.
My report layout is DB field with some textboxes. The report needs to be exported to Excel format. In excel where the blank textboxes are, the user must be able to key in a 10 decimal value data. So I inserted a textbox in the detail section next to the Name field. I am able to export to excel. But when I key in numbers, I am able to key in upto 9-decimal places, the moment I key the 10 decimal and I see only 9 appearing. Not sure why.
On a separate note, I excel, in a new sheet when I tried to key in 10 decimal value I have no issues. So no problem with excel, probably with export of blank textbox.
Please someone help me understand how I could use a blank field in the report to populate a 10-decimal data after export.