Solved Simple Query Design

[Marshall Brooks]

@mike60smart - Is there a way to add the red X Close button to the form, instead of having to right-click and choose Close?

 

[mike60smart]

@mike60smart - Is there a way to add the red X Close button to the form, instead of having to right-click and choose Close?

Hi
Always best to add a Command Button as shown in the attached.

 

[Marshall Brooks]

Thank you!!!!

 

[Pat Hartman]

but I'm not sure if Integer will allow leading zeros.

Numeric data types do not allow leading zeros because they are numbers and numbers by convention do not support leading or trailing zeros. If your text field included leading zeros, 0100 would sort in its proper place after 0001, 0002, 0003, etc.

 

[Marshall Brooks]

@Pat Hartman - Thanks for the confirmation. My data had 05, 11, 100 and it sorted like that until I added length to the sort algorithm.

 

[Pat Hartman]

You're welcome.