Hi Ashley
Not sure what's going on but I use the Open AI App that Richard made with no problems. Can you show us the error that you are getting?

john

Hi Ashlyn,

I had the same problem. With help from Richard's code volt, the following function saved the day:

Public Function DeleteTrailingChar(ByRef S As String) As String

    While Len(S) > 1 And (Right(S, 1) = Chr(10) Or Right(S, 1) = Chr(13) Or Right(S, 1) = " " Or Right(S, 1) = """""" Or Right(S, 1) = Chr(9))
        S = Left(S, Len(S) - 1)
    Wend
    DeleteTrailingChar = S
End Function


To use it, just call it to process your string:

S = DeleteTrailingChar(S)

Thank you both John & thanks Sami for the suggestion to use the DeleteTrailingChar function before my SendStr to the API, unfortunately, on first blush, this didn't solve my dilemma. I have the API helping me to update an ongoing list of assessments that are on my caseload, which involves having VBA copy a previous response to another text box and combining it with more content to then use in another SendStr to generate a response. Something is happening during this process, some tab, line break or character that, despite all of my efforts I'm not able to remove before attempting to send.  I changed a bit of the VBA trying to copy and paste an output here that I could use as an example, now all of a sudden it seems to be working fine. I have hardcoded a hyperlink to an online site that has a cleanup utility that afterwards using I've been absent of a problem. Perhaps if the error returns, I'll make use of that until if and when it becomes bothersome.

BTW, Richard ROCK'd with this TechHelp, never imagined I could press buttons and have Access generate in minutes something that would take me near an hour to complete with half the quality or sophistication. Thanks again!

Yeah it's just a matter of stripping out characters that cause issues. Trial and error.