Recent content by kitty77

I see... Thanks.

When I go to properties, I don't see the unblock checkbox like in some tutorials? Thanks.

Thanks for the example but keep you 2 cents to yourself next time. Sorry I'm not an expert like you!

Can you provide me an example? The field is [cust] Thanks.

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 ADVA80403 Advanced AIRC23072 Air BETV16523 Tom Need it to look like this. ADVA80403 AIRC23072 BETV16523

It gets rid of the comma and the extra space but everything is on one line now.

So, using my example: =[Street Address] & (Chr(13) + Chr(10) + [Street Address Line 2]) & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip Code] Where do I change it so the ", " and the " " don't show? Before the those or before the city, state, zip? Not clear. Sry.

Perfect! One last small item. How can I get rid of the comma (", ") and the extra space (" ") if both Address/s are null?

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 blank line?

When I try this: =[Street Address] + (Chr(13) & Chr(10) & [Street Address Line 2]) & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip Code] I get the same results as before?

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) & Chr(10) & [Street Address Line 2] & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip Code]

That did it!

Yes, on a textbox on a form.

I tried that but it keeps putting square brackets around the vbCrLf? =[Street Address] & [vbCrLf] & [Street Address Line 2] & [City]

I'm combining a few fields and need to have a return (next line) after each. =[Street Address] & [Street Address Line 2] & [City] Street Address Street Address Line 2 City