How to Create a Multi-Column Combo Box in MS Access, Adjust the Width and Bind it to the Table

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 8

  • @seanmackenziedataengineering
    @seanmackenziedataengineering  3 ปีที่แล้ว +3

    What did you think of this technique? Ever had a problem getting your comboboxes just right?

    • @lisykim3631
      @lisykim3631 2 ปีที่แล้ว +1

      Thank you sir !

  • @salahsaadi3623
    @salahsaadi3623 ปีที่แล้ว +1

    are there justify text in combo box for long text like in word

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  ปีที่แล้ว +1

      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

  • @ryeshegabriel
    @ryeshegabriel 3 ปีที่แล้ว +2

    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")

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  3 ปีที่แล้ว

      Looks like you need a space before first & in your expression. Let me know!

    • @ryeshegabriel
      @ryeshegabriel 3 ปีที่แล้ว

      @@seanmackenziedataengineering actually the syntax is workjng on access2007 but when i run it on ms access2016 ive got an error #Format

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  3 ปีที่แล้ว

      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.