Text Box within a report

[crowegreg]

Using Access 2010, within a report I have a text box. The control source has this line, =[Forms]![frmNewQuote]![VehicleMake] & " " & [Forms]![frmNewQuote]![VehicleModel]



My problem is it is only printing the first field. If I create 2 text boxes, and seperate the data, that works fine. But I need to only use 1 text box. Thanks in advance for your help!!

[June7]

That's odd. Should work, does for me. Can't replicate the issue. Do you want to provide project for analysis?

[crowegreg]

Here's copy of whats needs. The report is based off the form. I've created a text field which should display year, make, and model.

[June7]

The data is in the textbox but some reason wants to wrap onto second line. Expand height of the texbox and will see the model. I re-typed the data in the table. That cleaned something up because then the string displays properly.

[crowegreg]

You are good! With what you wrote, I did some testing. If I look at the length of data within that field, it does not match with the number of characters that are visible. If the other characters are line returns, what will remove them?

[June7]

Options:

1. retype the data

2. VBA function - review http://superuser.com/questions/30270...-with-new-line

The Find and Replace dialog doesn't seem able to handle these non-printing special characters. Nor does the Replace function in an UPDATE query.

[crowegreg]

I import this type info multiple times throughout the day. Looks like I need to do some scrubbing while the data is being imported in. How do I determine what characters are within a field that are not being displayed?

[June7]

How are you doing the import? The import wizard won't deal with this. You just might have to scrub after import.

[crowegreg]

I receive this data in the form of emails. I might receive 20 emails per day. I need to add some scrubbing when I'm importing. On the data that I have within the DB at this time, I used the replace command within one field, replacing character return with "". It reduced the length within the field data by 1, but their is still 1 character something that is not visible. I ran the same replace command again, but nothing else was removed.

[June7]

I could not get the Replace dialog to work on return character. How did you do it?

A return in Access/VBA is really a two-part code:

1. in Access or VBA can use Chr(13) & Chr(10)

2. in VBA can also use constant vbCrLf, equivalent of vbCr & vbLf

[crowegreg]

I experimented with:
replace(string,chr(13),"")

The Len{string) was reduced by 1. But, the Len(string) is still greater by 1 then number of characters that are visisble. I can't figure out what else I should try.

[June7]

You did that in an UPDATE query or textbox? The UPDATE worked although did through error message. I used: Replace(Replace([Address],Chr(13),""),Chr(10),"")

Those are the only non-printing characters I could think would be involved. Never encountered this before and the VBA function is the only possible solution I could find.

[crowegreg]

I correctly the situation using VBA. Here are the two lines of code

strEmail = Replace(strEmail, Chr(13), "")
strEmail = Replace(strEmail, Chr(10), "")

For each of the variables, these 2 lines fixed my problem.