Yes, you can set the TextAlign property for the combo box. cboMyCombo.TextAlign = 2 for these: 0 = General 1 = Left 2 = Center 3 = Right 4 = Distribute
Good day, im doing a concatenation in my report, why is this syntax working in access 2007 and not on access2016? Pls help. Tnx =[Particulars]& " " & Format([SignedDate], "dd-mmm-yyyy")
Interesting. I tried the syntax in 2016, 2013, and 2019 and it works just fine in all three. It could be some control formatting on your text box or something like that. I experienced something similar before and fixed it by deleting the control, then recreating it and putting the expression in the new one.
What did you think of this technique? Ever had a problem getting your comboboxes just right?
Thank you sir !
are there justify text in combo box for long text like in word
Yes, you can set the TextAlign property for the combo box.
cboMyCombo.TextAlign = 2
for these:
0 = General
1 = Left
2 = Center
3 = Right
4 = Distribute
Good day, im doing a concatenation in my report, why is this syntax working in access 2007 and not on access2016? Pls help. Tnx
=[Particulars]& " " & Format([SignedDate], "dd-mmm-yyyy")
Looks like you need a space before first & in your expression. Let me know!
@@seanmackenziedataengineering actually the syntax is workjng on access2007 but when i run it on ms access2016 ive got an error #Format
Interesting. I tried the syntax in 2016, 2013, and 2019 and it works just fine in all three. It could be some control formatting on your text box or something like that. I experienced something similar before and fixed it by deleting the control, then recreating it and putting the expression in the new one.