Solved Reason of #Size! Error in Report Text Field (1 Viewer)

[Pac-Man]

Hi,

What are reasons of #Size! error on report text fields. A report in accde is running fine on one PC with access 16 office 2019 while same file is giving #Size! in the text field on other pc on runtime 2016. Text field hold string value. Moreover, control source of the text box is a function that returns the string value.

Best Regards
Abdullah

 

[arnelgp]

increase the size of the Field (or make it Long Text).

 

[Pac-Man]

Thanks @arnelgp for reply. The issue is resolved and that was not a issue but a mistake at that specific end. Older backed file was being used at that pc and that backend file didn't have required record in the table required for the function to run.

I reported this post for deletion as it was not an issue but a mistake so that to save the time of people like you who respond to solve OP's issue but I was suggested to post the comment here instead of deletion because someone else may experience similar issue.

Thanks again.
Best regards