kitty77's latest activity

  • K
    kitty77 replied to the thread Unblock Checkbox.
    I see... Thanks.
  • K
    kitty77 posted the thread Unblock Checkbox in General.
    When I go to properties, I don't see the unblock checkbox like in some tutorials? Thanks.
    • Screenshot 2024-04-21 194821.png
  • K
    kitty77 replied to the thread Query Data.
    Thanks for the example but keep you 2 cents to yourself next time. Sorry I'm not an expert like you!
  • K
    kitty77 replied to the thread Query Data.
    Can you provide me an example? The field is [cust] Thanks.
  • K
    kitty77 posted the thread Query Data in General.
    I have a table that has data that looks like this... I need to create a query that gives me everything before the first space...
  • K
    kitty77 replied to the thread Format.
    It gets rid of the comma and the extra space but everything is on one line now.
  • K
    kitty77 replied to the thread Format.
    So, using my example: =[Street Address] & (Chr(13) + Chr(10) + [Street Address Line 2]) & Chr(13) & Chr(10) & [City] & ", " & [State] &...
  • K
    kitty77 replied to the thread Format.
    Perfect! One last small item. How can I get rid of the comma (", ") and the extra space (" ") if both Address/s are null?
  • K
    kitty77 replied to the thread Format.
    Sometimes, =[Street Address] can be null and [Street Address Line 2] have a value. So, how can I check for either null and remove that...
  • K
    kitty77 replied to the thread Format.
    When I try this: =[Street Address] + (Chr(13) & Chr(10) & [Street Address Line 2]) & Chr(13) & Chr(10) & [City] & ", " & [State] & " "...
  • K
    kitty77 replied to the thread Format.
    So, here is my code... How can I make it remove the extra line if [Street Address Line 2] is empty? =[Street Address] & Chr(13) &...
  • K
    kitty77 replied to the thread Format.
    That did it!
  • K
    kitty77 replied to the thread Format.
    Yes, on a textbox on a form.
  • K
    kitty77 replied to the thread Format.
    I tried that but it keeps putting square brackets around the vbCrLf? =[Street Address] & [vbCrLf] & [Street Address Line 2] & [City]
  • K
    kitty77 posted the thread Format in General.
    I'm combining a few fields and need to have a return (next line) after each. =[Street Address] & [Street Address Line 2] & [City]...
Show older items
Top Bottom