Hi,
A label on a Form has a value of the format 1234-4567 (eight numbers separated by a -).
I need to read the last four digits and use them as a number so I can add or subtract or it from other number.
How can I do that ?
Khalil
Use value of a label on a form
Competent Performer
Windows 10 
Access 2010 32bit
Hi,
A label on a Form has a value of the format 1234-4567 (eight numbers separated by a -).
I need to read the last four digits and use them as a number so I can add or subtract or it from other number.
How can I do that ?
Khalil
VIP
Windows 10 Access 2007
Not heard of the Right() function? or the Val() functions.
Labels do not have Values, but do have Captions BTW
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Competent Performer
Windows 10 Access 2010 32bit
Hi,
Thank you very much.
My issue was with the caption
Khalil
How do I make the Label.SizeToFit Method only adjust the label vertically?
Change Label on Form
Form label in a report
Posting Permissions
Reply With Quote